Snowflake Costs
Learn about and set monitors on your Snowflake costs in Secoda
Last updated
Learn about and set monitors on your Snowflake costs in Secoda
Last updated
Everyone is thinking about cost containment these days, and so are we! You can track your Snowflake costs, using our Snowflake Cost widget as part of the Analytics Dashboard.
We provide cost analysis for everything in your Snowflake warehouse. This information is provided through the information schemas of each table, for the entire warehouse.
Visualizing your cost trends using the Widget will not impact your overall costs, as Secoda is already querying the information schemas to extract the metadata for your workspace. To learn more about what queries Secoda makes to your Snowflake instance, navigate to the Secoda impact on Snowflake Costs section below.
You can even use our monitoring features on a Snowflake cost widget to be alerted about changes to daily costs. Simply create the widget, then use the three dot menu to create a monitor.
Add filters on usage type and balance source, and voila! You can catch changes before they become larger issues.
At every sync, Secoda runs queries on your Snowflake instance. Generally, these queries costs anywhere between 0.1 to 1 credit in total.
Secoda queries Snowflake in two ways during each sync. The first, is querying the information schema of each database in Snowflake. The second, is querying the snowflake.account_usage.query_history table. From these two queries, Secoda is able to extract and calculate Metadata, Cost, Lineage, Query History, Popularity and profile the Snowflake Columns.
Note, queries outside of a sync, such as those from Monitors, are not included in the cost above, and can vary depending on how the feature is implemented in your workspace.
