Last tested: Jun 17, 2019
At first thought, it might make sense to assign a blank value to override any default value input for user attribute values in the User Attribute page in the Admin Panel. However, if we assign blank override values for Admins or Unrestricted Access groups, Looker will interpret the blank as a value not having been assigned to a user. In this case, any default value specified will override the blank.
In cases where using access filters to restrict data access amongst users with user_attributes
, while allowing certain users or groups all access, we can set user attributes as such:
%
. To include null values, set the user attribute to %, NULL
.>0
or NOT NULL
. To include null values, set the user attribute to >0, NULL
.This content is subject to limited support.