Cleaner where conditions with dates with Bigquery Explore

Looker Q&A Looker
, ,
1

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

2

What does the SQL look like if you remove datatype:date ?

3

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.