Configure Tableau to Gain User Level Observability

Overview

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:

• Tableau Desktop
• Tableau Server
• Tableau Online

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:

• Talbeau Online
• Tableau Server

Modifying Tableau to Gain User Level Observability

1. Navigate to the Tableau workbook that you would like to edit on Tableau Online.
2. Select the Edit icon on the toolbar.
3. From the Web Editing menu select the desired data source from the Data Menu and then Edit Data Source.
4. Ensure the Data Source in the lower left corner of the window is selected.
5. Select the carrot on the right of your data source block, then select Initial SQL.
6. Enter the following SQL statement:

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.

7. Click sign in to accept the exits and the File>Save menu item to save the workbook.

You should now have user level observability of your desired data!

‍