Tableau allows the dashboard author to set an Initial SQL command for use on the data connection to the database. This enables ALTR to get user level information for each user/session that is querying the database. User level information can be observed in Analytics, detected in the query log, and applied to governance policy.
Tableau can be configured to work with ALTR on the following platforms:
The simplest configuration method utilizes Tableau Online; an Initial SQL command that can be used for all platforms can be found on Tableau’s help page. Before you start, ensure that the Data Source that you want to have ALTR observe is configured and working properly. When adding the initial SQL command, you will need to have the ability to publish and overwrite to the data source as well as web editing. For more information on Tableau permissions, see the following pages:
Once this query is successfully processed, ALTR will be able to interpret the all user snowflake user names and write them to the ALTR username.
You should now have user level observability of your desired data!