Cleaner where conditions with dates with Bigquery Explore

  • 11 June 2021
  • 1 reply

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,





Explore filter:


Lookml definition:


Resulting SQL 


1 reply

Userlevel 6
Badge +1

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