Overriding User Attribute Default for Admins or Unrestricted Access Groups

Knowledge Drop

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 give an admin or other user access to all non-null values of a string field, set the user attribute data type to String Filter (advanced), and use a value of %. To include null values, set the user attribute to %, NULL.
  • To give an admin or other user access to all non-null values of a number field, set the user attribute data type to Number Filter (advanced), and use >0 or NOT NULL. To include null values, set the user attribute to >0, NULL.

This content is subject to limited support.                

Version history
Last update:
‎04-05-2021 03:32 PM
Updated by: