Get Started Sign In

Using email rather than username for identity attribution in Tableau

Tableau users who rely on Cyral for identity provider-based user identity attribution may, depending on their identity provider (IdP) configuration, see the wrong user attribute logged in Cyral as the user's SSO username. 

If your organization uses the IdP user's email (rather than the IdP username) as the SSO username (and if usernames are not the same as users’ email addresses), then you will need to make the following changes in Tableau and Cyral to ensure that SSO users' email will be logged and used for policy enforcement:

  1. In your Tableau console, in your data source(s) that connect to repositories watched by Cyral, edit the connection's initial sql value so that it uses instead of cyral.enduser. See the cyral documentation page for Tableau ( ) for details.

For example, for Redshift the initial sql would be:

SELECT '', [TableauServerUser]

  1. Using the Cyral API, configure the Cyral connection driver for Tableau to process email identities by setting the attribute, useEmailCarrier. Use the Cyral API to set this, as shown in this example:

curl -H "Authorization: Bearer $TOKEN" -H "Content-Type: application/json" -s -X PUT

 -d '{ "category": "builtin", "name": "testTableauDenodo", "parameters": "{\"applicationName\": \"testTableauDenodo\", \"useEmailCarrier\":true}", "purpose": "connectionDriver", "templateType": "tableau"

Learn more:

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.