Knowledge Drop

How do I apply a filter for a whole view, regardless of what explore it's used in?

Userlevel 5
  • Looker Staff
  • 172 replies

Last tested: March 2021



You might want the behavior of sql_always_where to apply the view level rather than the explore level.

In that case, you can:

  1. Build a derived table with the desired WHERE clause,

  2. or use a sql_table_name like:

sql_table_name: (SELECT * FROM table WHERE X != 0) ;;

It is a feature request to be able to do this natively/with a parameter.


This content is subject to limited support.                

0 replies

Be the first to reply!