Tracking Snowflake OAuth Token Expiration Dates

Published: 07 Feb 2022
Last Modified Date: 08 Feb 2022

Question

How to track the expiration dates for Snowflake OAuth tokens since they expire every 90 days (by default).

Environment

Tableau Server
Snowflake

Answer

Use a custom admin view:

If you have not already done so, enable access to your Tableau Server repository by following the instructions in this document Enable access to the Tableau Server repository.
Download the workbook (.twb) attached to this article, and open it in Tableau Desktop.
In the PostgreSQL connection dialog box, click 'Edit connection', update the Server field with the name or URL for Tableau Server and click 'Sign In'. (For a distributed server installation, enter the name or IP address of the node where the repository is hosted.)

Additional Information

You can configure a data-driven alert for this view to send notifications to key people when the data reaches important thresholds.

For more control over the data-driven automation, use the VizAlerts plaform, which is Community-supported. This means while Tableau Professional Services team may be engaged to assist with the deployment and usage of this tool, VizAlerts is not officially supported by Tableau Software: It is a community-built and community-supported tool. Please bring questions and issues about this tool to the VizAlerts Group created on the Tableau Community site.