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

[sam8]

Knowledge Drop

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.