This QuickStart provides instructions on how to set up Sigma's Snowflake Cost per Query template.

This template give you a prebuilt analysis of Snowflake costs by Sigma workbook / user and by Snowflake user, role and warehouse.

There are two steps to setting up the template:

1. Create the query_history_enriched table in your Snowflake account
2. Launch the template in Sigma and Swap Sources to the table created in step 1

Target Audience

Anyone who is trying to calculate the Snowflake cost-per-query or aggregate costs across different dimensions.

Prerequisites

• A computer with a current browser. It does not matter which browser you want to use.
• Access to your Snowflake account with the ability to create tables and grant access to the role used in your Sigma connection.
• Access to your Sigma environment.

Sigma Free Trial

What You'll Learn

How to deploy Sigma's Snowflake Cost per Query template.

What You'll Build

• The "query_history_enriched" table in Snowflake that calculates the cost (in currency) for every query.
• A Sigma workbook that calculates query cost across Sigma workbooks / users and across Snowflake users, roles and warehouses.

One way to create the query_history_enriched table is by deploying the dbt-snowflake-monitoring dbt package from Select.

This package has a model called query_history_enriched that enriches the Snowflake query_history table with query cost information. It will calculate the actual cost (in currency) for every query run in your Snowflake account.

Once the package has been deployed, Sigma needs to be able to access the table(s) created.

1. Identify the role used in your Sigma connection.
2. Run the following command:

grant select on table {database name}.{schema name}.query_history_enriched to role {role used in Sigma connection};

Note that you may need to grant usage on the database and schema that host this table.

Verify that you can see the new table(s) in the Sigma connection browser:

Next, advance to step 4.

Another way to create the query_history_enriched table is by running the attached SQL script in your Snowflake account.

Download the SQL script here!

The script requires you to specify a few parameters:

• materialization_role_name : the role that will create and update the query_history_enriched table
• database_name / schema_name : the target destination for the query_history_enriched table
• materialization_warehouse_name : the warehouse used to create and update the query_history_enriched table
• sigma_role_name : the role used in your Sigma connection

Run the SQL script in your Snowflake account, and then verify that you can see the new table(s) in the Sigma connection browser.

Once you have created the query_history_enriched table, go to Sigma.

From the home page, navigate to the Templates section, then to External.

Click on the Snowflake Cost per Query template:

You will be prompted to swap data sources. Click Swap Now:

Verify that Sigma has found the query_history_enriched table and click Swap Now:

Click Save As and give your workbook a title.

That's all there is to it!

You should now see the Snowflake Cost per Query Template on top of your own data.

For example:

In this QuickStart we created the query_history_enriched table and launched Sigma's Snowflake Cost per Query template.

If you're interested in a Snowflake Optimization tool, check out Select!

Additional Resource Links

Be sure to check out all the latest developments at Sigma's First Friday Feature page!

Help Center Home
Sigma Community
Sigma Blog