Hey everyone!
I’m a data scientist/engineer who is pretty new to Looker. Currently I’m trying to use Looker Explores to enable data self-service for my team’s non technical members. I would like to know how to create cleaner date filter logic in the generated SQL.
Right now, adding a user defined date filter in Explore is generating a super messy SQL for something that should be really simple.
I’m sure I’ve overlooked some docs so would appreciate this community’s guidance!
Thank you,
Sung
Explore filter:
Lookml definition:
Resulting SQL
What does the SQL look like if you remove datatype:date ?
Hey Dawid, thank you for the reply. Removing `datetype:date` results in this Bigquery error message:
invalidQuery: No matching signature for operator >= for argument types: DATE, TIMESTAMP. Supported signature: ANY >= ANY at [7:11]
Run
Attached screenshot of generated SQL.