Just realized itâs actually a FILTER (not an option for the recipient of scheduled content)⌠meaning youâd still have to enter every single e-mail address⌠you probably already have security features, but you could also consider pulling a list from a LookML Dashboard and then pasting applicable e-mails when creating your Schedules⌠that is, if you even utilize User Attributes of course.
Addâl info from the same doc I initially quoted below, sorry for the oversight here!
Filters
Filters on Explores, Looks, dashboards, and legacy dashboards can be set to a user attribute to customize the query based on the user running it.
For example, you could create a user attribute called salesforce_username and configure each Looker user so that their value for it is their Salesforce username. Then you could set a filter on a dashboard to the salesforce_username user attribute and each user would see that dashboard filtered for their particular Salesforce username.
Configuration
In the FILTERS section of the Explore, Look, or dashboard:
docs (66.3 KB)
-
Select the matches a user attribute option on the desired filter.
The select box to the right automatically updates with a list of user attributes that have the same type as the filterâs field, such as number, string (text), date, and so forth. Looker displays your value for each user attribute in parentheses.
-
Select the desired user attribute.
Advanced filter syntax
If youâd like to do something more complex than a simple equality check for the filter, select matches (advanced) and reference the user attribute using a Liquid variable:
{{ _user_attributes[âname_of_attributeâ] }}
For example, suppose you need to apply an sf_ prefix to the value of the salesforce_username user attribute because that is how the values are stored in your database. To add the prefix to the user attribute value, use the _user_attributes Liquid variable syntax:
sf_{{_user_attributes[âsalesforce_usernameâ]}}
You can use the same pattern to insert user attributes into LookML dashboard filters and dashboard element filters.
Scheduled dashboards and Looks
Dashboard and Look filters can be set on a per-schedule basis, including the option to use a user attribute. This lets you customize the data delivery results for each email recipient. You can customize deliveries for content that are sent as one-time deliveries and recurring deliveries.
For example, you could create a user attribute called salesforce_username and set the value to each userâs Salesforce username. Set a filter on a dashboard or Look schedule to the salesforce_username user attribute so each recipient gets that dashboard filtered by their Salesforce username.
Prerequisites
Only Looker users have user attribute values set, so every recipient of the data delivery must have a Looker account. User attributes are applied by running the dashboard or Look once for each recipient.
Configuration
Open the Scheduler for the Look, legacy dashboard, or dashboard that uses the new dashboard experience:
docs (66.3 KB)
-
In the Filters section, select the matches a user attribute option on the desired filter.
The select box to the right automatically updates with a list of user attributes that are the same type as the filter. Your own value for each user attribute will be shown in parentheses.
-
Select the desired user attribute.
-
Check the run schedule as recipient checkbox next to the Email options field.