How can the developer determine to which fields this parameter should be applied through SQL Runner?

A developer has User Specific Time Zones enabled fora Looker instance, but wants to ensure that queries run in Looker are as performant as they can be. The developer wants to add a datatype: date parameter to all dimension_group definitions without time data in a table-based view, so that time conversions don’t occur for these fields.

How can the developer determine to which fields this parameter should be applied through SQL Runner?
A . Open the Explore query in SQL Runner and validate whether removing the conversion from date fields changes the results.
B . Open the Explore query in SQL Runner to determine which fields are converted.
C . Use the CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.
D . Use the Describe feature in SQL Runner to determine which fields include time data.

Answer: C

Explanation:

Reference: https://community.looker.com/technical-tips-tricks-1021/how-looker-does-timezones-and-how-to-troubleshoot-them-25477

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments