Use Zing’s Row Level Security and User Attributes capabilities to create questions which are dynamic to which user is viewing a question or dashboard. For instance,
This video walk through step-by-step:
Here’s how to do it:
Create a lookup table within your data source, which to maps a user’s logged in email address to attributes about them.
It should have an ’email’ field, and any other field names you’d like to be able to access as user attributes to customize query results.
From the Zing Web Console, or the mobile apps, click on ‘data sources’ then ‘add’ to connect to your Snowflake, Postgres, mySQL, ClickHouse, Trino, Presto, Starburst, MS SQL, Google BigQuery, Google Sheets, or Databricks source.
Invite colleagues by tapping ‘invite’ from the web console, or inviting a user from the mobile or web apps from a specific question.
From the Zing Web Console,
Tap on ‘Data Sources’ then ‘Settings’
Turn on the ‘Row Level Security’ switch and specify the lookup table, and the email field (this is used as the key to lookup other fields for a given user)
Asking questions in Zing that use a user’s specific attributes is achieved by applying a filter to questions.
where attribute is any field name.
For the example lookup table above, available attributes are:
So if you wanted each user to see the sum of sales for their office location, you’d add a filter on the Office_Location field as follows:
From there, you can save this question, add it to a dashboard, or share it with colleagues – and the results of the question will be filtered to their specific user attributes.
Detailed setup instructions are here in the docs. And of course, feel free to reach out to our team if you need hand!