Provide comprehensive insights around your Snowflake deployment and usage across all your tables, databases, and users. See how these metrics trend over time and compare to prior periods to ensure you're scaling effectively.

Snowflake provides comprehensive database performance information through their Sharehouse (rather than the information schema, as recommended by the Snowflake Product team. Make the most of this information and your Snowflake investment using Snowflake’s Block for Cost and Usage. The Block highlight several of the most impactful opportunities for cost saving and performance improvements:

  • Identify your longest running queries and refactor tables or query syntax to improve speed

  • Recognize your most costly queries and modify queries, tables, or join logic to reduce your recurring spend

  • Target the troublesome users and prevent them from issuing runaway queries and slowing down your environment

See the code