Getting Started: How to set up the Snowflake account usage dashboards
Included below are instructions on how to set up your Account Usage dashboards using our downloadable workbook.
Part One: Enable access in Snowflake
By default, only account administrators (users with the ACCOUNTADMIN role) can access this data. However, privileges can be granted to other roles in your account to allow other users access. If you are not an account administrator, you will need to be granted access.
Part Two: Open Tableau’s Account Usage dashboards
Download and open the Snowflake Account Usage Tableau workbook. You will need Tableau Desktop (version 2018.3 or greater) to open this file. If you have not downloaded Tableau Desktop before, you can start a trial here.
Part Three: Direct the workbook to your Snowflake Data Warehouse
- Upon opening the workbook you will be prompted to Edit the Data Source Connection. Ignore that prompt and instead create a new Sheet.
- Once on a new Sheet, establish three data source connections to your Snowflake instance. One data source for each of the tables identified below. If you have never connected to Snowflake from Tableau before, you can learn how here. (Please note: a driver is required.)
Database: SNOWFLAKE Schema: ACCOUNT_USAGE Table: QUERY_HISTORY
Database: SNOWFLAKE Schema: ACCOUNT_USAGE Table: WAREHOUSE_METERING_HISTORY
Database: SNOWFLAKE Schema: ACCOUNT_USAGE Table: STORAGE_USAGE
Please note: As of May 2019 these tables do not contain any cost information pertaining to Materialized Views, Automatic Clustering, or Snowpipe. That information is contained in separate tables.
- It’s important to note that these dashboards are designed to give you complete insight into your Snowflake account usage history. The Account Usage tables contain up to 12 months of your account usage, and depending on the extent of your adoption, may contain a large amount of data. Please keep in mind that dashboard performance is proportional to the extent of your adoption. If you'd like to focus analysis on a specific period of time consider using a data source filter or extracting the data after connecting successfully.
- Once you have connected to all three tables, replace those data sources with the respective tables in the workbook.
- This will need to be done for all three data sources.
- Right click and “Close” each of the old data sources.
That’s it! Your dashboards are now ready to be explored. If you’d like to share with your team, publish these data sources and publish the dashboards to Tableau Online or Tableau Server so that you can collaborate with any other data stakeholders.
Check out a completed example (using anonymized data) of the Snowflake Account Usage workbook on Tableau Public.
Get more value from Tableau and Snowflake
And of course, there’s no need to stop there. While we’ve provided a number of ways to see and understand your data, you can use Tableau’s industry-leading drag-and-drop experience to customize your own dashboards. Let your curiosity and creativity drive you to the story that best brings your data to life.
Interested in sharing your unique ideas? Check out our Community Forum Discussion to collaborate on ideas and connect with the Tableau and Snowflake community.
No matter where you are on your data journey, Tableau and Snowflake are committed to guiding you along the way. With data to light your path, you can act confidently, knowing that all your cloud decisions are informed decisions.
Special thanks to Shobha Joshi (Snowflake), Kelly Hotta (Snowflake), and Madeleine Corneli (Tableau) for their collaboration in the development of these materials.