Question

Cleaner where conditions with dates with Bigquery Explore

  • 11 June 2021
  • 1 reply
  • 16 views

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 

 


1 reply

Userlevel 6
Badge +1

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

Reply