Skip to content

ALTR’s Tableau integration captures the identity of the Tableau user and session behind a query, so that activity appears in Query Log under the originating Tableau user instead of a single shared service account. Tableau Desktop (when signed into a Tableau server), Tableau Server, and Tableau Online are all supported.

The integration works by having Tableau execute an Initial SQL statement every time it connects to a database. That statement records the current Tableau user and session, which ALTR then associates with the queries that connection runs.

To make Tableau user information visible to ALTR:

  1. Navigate to the Tableau workbook you want to connect.

  2. Click the Edit icon on the toolbar.

  3. From the Web Editing menu, select the data source from the Data menu, then click Edit Data Source.

  4. Confirm the data source is selected in the lower-left corner of the window.

  5. Click the caret to the right of the data source block, then select Initial SQL.

  6. Enter the following SQL statement:

    set altruser = [TableauServerUser]
  7. Click Sign In to accept the edits, then select File > Save to save the workbook.