bypass_suggest_restrictions

Use caution when using this parameter, as it can reveal sensitive data if used incorrectly.

Usage

view: view_name {
  dimension: field_name {
    bypass_suggest_restrictions: yes
  }
}

Hierarchy View File view Field Type bypass_suggest_restrictions

Possible Field Types Dimension, Dimension Group, Filter, Parameter Accepts A Boolean (yes or no)

Definition

Typically, when sql_always_where or access_filter is used, filter suggestions are restricted for that Explore. This prevents users from seeing a filter suggestion that does not apply to them.

For example, you might be using access_filter to limit users to their company's data. If one of those users added a Project Name filter, you might not want them to see the names of projects from other companies.

If you are certain that there are no possible values in a particular dimension or filter field that would reveal sensitive information, you can re-enable filter suggestions like this:

dimension: project_name {
  sql: ${TABLE}.project ;;
  bypass_suggest_restrictions: yes
}

-

If there are values in a field that would reveal sensitive information, the full_suggestions parameter can enable you to get properly filtered suggestions. However, bypass_suggest_restrictions is more performant, so use it when possible.