Cleaner where conditions with dates with Bigquery Explore

[SungOh]

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 

[Dawid]

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

[SungOh]

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.