Time frame dimension is not working in Dev

[Siva19]

Hello Looker Team,

Context:
We have built SQL-based derived views, where we created a time frame dimension. This dimension is working correctly in the production environment, but it is not functioning in the Dev environment. The code is identical on both sides.

I have included the code for reference in the attached figure.

If I select “View in Explore” within the selected time frame filter (Day, Weekly, or Monthly) in selected frame filed , the timestamp changes in the production environment. However, in the DEV environment, there is no change sql code in data .

production environment:

DEV environment:

Appreciate your help.

[dsimeonova · Accepted solution]

Hey @Siva19 !
This can occur when you have different versions of the derived table and when the derived table is "PDT". 
Whenever you work on DEV environment, Looker will create a version of the derived table on your database (check the Looker schema that you defined as scratch schema in the Connection of the database).
That could be one issue. If you are using PDTs I would suggest you to delete the table from your database and recreate it again from Looker (exploring the PDT would be enough to rebuild it).

Please let me know if this worked and if this was at the end the issue. It could help other people in future 😊

Kind regards,
Desi

[Siva19]

The tables that we are different table. We have different table for Dev environment and another table for prod. And we created the view using SQL runner and still it is not working.

[dsimeonova]

Hey @Siva19 !
Did you try to delete the tables from your database and then run them again from Looker?