Configure query tags
You can now configure query tags on your Snowflake connection to allow you to filter on users, groups, or other ThoughtSpot variables when auditing the Snowflake query logs. You can do this when creating a new connection, or by editing an existing connection. For more information, see Add a Snowflake connection and Edit a Snowflake connection.
Configure query tags on an existing Snowflake connection
To edit a Snowflake connection:
-
Select Data in the top navigation bar.
-
Open the Connections tab in the left navigation bar.
-
Select the connection you want to edit.
-
Select Edit connection from the More menu.
-
On the Edit configuration page, go to Advanced Config (Optional):
-
Enter query_tag under Key.
-
Enter one of the supported variables, or a static value that you want to be able to filter on under Value.
Supported variable
Desctiption
ts_username
ThoughtSpot username. Allows you to filter and view queries made by a specific user.
ts_email_domain
Email domain associated with ThoughtSpot. Allows you to filter and view queries made by users with emails associated with your ThoughtSpot connection.
ts_groups
ThoughtSpot group name. Allows you to filter and view queries made by a specific group.
ts_orgid
ThoughtSpot Org ID. Allows you to filter and view queries based on the Org ID.
ts_orgname
ThoughtSpot Org name. Allows you to filter and view queries based on the Org name.
You can pass a static value, such as 'thoughtspot' to see all queries related to ThoughtSpot.
-
-
Click Next.