Snowflake Sessions

Snowflake is a cloud data warehousing platform known for its scalability and ease of use.

This page guides you on questions to manage your Snowflake data warehouse, monitor data loads, and optimize query performance.

Key areas of focus

Below are some useful questions to ask when managing your Snowflake setup:

General resource management

• What databases and schemas are active in my Snowflake account?
• Are there any unused warehouses that can be scaled down?
• How can I view my current Snowflake storage and compute usage?

Data loading & ETL

• What are the recent data loading activities in my Snowflake instance?
• Are there any failed or incomplete data loads?
• How can I monitor performance on specific ETL processes?

Query performance & optimization

• Which queries are currently consuming the most resources?
• How can I optimize slow queries in my warehouse?
• Are there any materialized views or indexes that could help improve performance?

Cost management & resource allocation

• What are the costs associated with each warehouse and database?
• How do I monitor query costs and find optimization opportunities?
• Are there any warehouses running at low utilization that I can pause?

Security & compliance

• How are my user permissions and role hierarchies set up in Snowflake?
• Are there any recent access anomalies or failed login attempts?
• How can I enforce compliance with data privacy and security standards?