Snowflake¶
Connect Snowflake to track warehouse compute costs, query spend, and optimization opportunities in CloudVerse AI.
What you get¶
- Warehouse and cluster cost and utilization
- Query-level cost analysis (expensive, frequent, inefficient queries)
- Pipeline and job cost tracking
- Storage and dataset cost monitoring
- Optimization recommendations for idle warehouses and inefficient queries
Prerequisites¶
- Snowflake account with
ACCOUNTADMINor billing read access - A dedicated service user with
SNOWFLAKEdatabase read permissions
Connect Snowflake¶
- Go to Settings > Integrations.
- Select Snowflake.
- Enter a connection name — for example,
snowflake-production. - Enter your Snowflake Account Identifier, Username, and Password (or key-pair credentials).
- Finish the flow and wait for initial data ingestion.
Verify the connection¶
- Open the Snowflake connection detail page in Settings > Integrations.
- Confirm the status indicators are green.
- Open Data & AI Platform > Data Platform and select Snowflake to verify warehouse and query data.
Data expected¶
| Data | Used for |
|---|---|
| Warehouse compute usage | Warehouse spend, idle analysis, and optimization. |
| Query history | Expensive, frequent, inefficient, and high-scan query review. |
| Table and storage facts | Dataset growth, storage cost, and table-level cost drivers. |
| Account usage metadata | Ownership, filtering, and allocation context. |
Best practices¶
- Create a dedicated read-only service user for CloudVerse rather than using an admin account.
- Grant access to
SNOWFLAKE.ACCOUNT_USAGEviews for full cost and usage visibility. - Rotate credentials on schedule and revalidate Data Platform coverage after rotation.
Troubleshooting¶
See Integration setup issues if data does not appear after setup.