Snowflake cost monitoring | Integrations

Why Pelanor for Snowflake cost monitoring?

Simple SQL-based setup through Snowsight
Query-level cost analysis with QUERY_HISTORY access
Warehouse metering and credit usage tracking
Storage cost visibility including time travel and failsafe
Organization-wide usage monitoring
Pipe usage and search optimization tracking
Read-only access through dedicated views

What will you gain from monitoring Snowflake with Pelanor?

Query cost intelligence

Understand exactly which queries, users, and warehouses drive your Snowflake costs. Access detailed metrics including bytes scanned, elapsed time, and credits consumed for complete cost accountability.

Warehouse optimization

Monitor warehouse utilization across all sizes and types. Track compute and cloud services credits separately to identify optimization opportunities and right-size your warehouses based on actual usage patterns.

Storage cost visibility

Get comprehensive insights into your storage costs including active data, time travel, failsafe, and clone retention. Track database-level storage trends across your organization to optimize data retention policies.

Organization-wide insights

View consolidated costs across all accounts in your Snowflake organization. Track daily usage in currency, service types by region, and identify cost trends to optimize your overall Snowflake investment.

FAQs

What is Snowflake cost monitoring?
Snowflake cost monitoring provides visibility into your data warehouse spending including compute credits, storage costs, and query-level attribution. Pelanor integrates through secure views in your Snowflake account to deliver comprehensive cost analytics without impacting performance.
What Snowflake data does Pelanor access?
Pelanor accesses read-only views of QUERY_HISTORY, WAREHOUSE_METERING_HISTORY, TABLE_STORAGE_METRICS, DATABASE_STORAGE_USAGE, and usage billing data. This provides complete cost visibility while maintaining security through minimal, read-only permissions.
How does the integration work?
Integration involves creating a dedicated PELANOR warehouse (X-Small size), user, role, and database with specific views. The entire setup is completed through SQL commands in Snowsight, taking just a few minutes to configure.
What authentication methods are supported?
Pelanor supports both password-based authentication and public-private key authentication. Choose the method that best fits your security requirements. Both options provide secure, encrypted access to your cost data.
Will this impact my Snowflake performance?
No. Pelanor uses a dedicated X-Small warehouse that's separate from your production workloads. The integration only creates read-only views, ensuring zero impact on your existing queries and operations.