Snowflake integration for Grafana Cloud
Snowflake is a cloud data platform that is designed to connect any type or scale of data and unlock seamless data collaboration. The Snowflake integration uses the Grafana Agent to collect metrics for monitoring a Snowflake account, including aspects such as credit usage, storage usage, and login success rates.
This integration includes six useful alerts and five pre-built dashboards to help monitor and visualize your Snowflake metrics.
Pre-install configuration for the Snowflake integration
This integration supports metrics provided by v0.0.1 of the Snowflake exporter, which is integrated into the Grafana Agent.
In order for this integration to work, Snowflake requires a user configured with the
ACCOUNTADMIN role, or a custom role that has access to the
Refer to the Snowflake documentation for instructions on how to enable other roles to access the
Install Snowflake integration for Grafana Cloud
- In your Grafana Cloud instance, click Integrations and Connections (lightning bolt icon).
- Navigate to the Snowflake tile and review the prerequisites. Then click Install integration.
- Once the integration is installed, follow the steps on the Configuration Details page to setup Grafana Agent and start sending Snowflake metrics to your Grafana Cloud instance.
Post-install configuration for the Snowflake integration
In order to start scraping Snowflake metrics, you must provide the following account details and credentials in the agent configuration file:
roleif the user is not configured with the
By default, the
scrape_interval is set to 30 minutes due to Snowflake’s large metric bucket time frames. To modify this interval, adjust the
scrape_interval field in the agent configuration.
Make sure to change the necessary fields in the following snippet according to your account details.
integrations: snowflake: enabled: true scrape_interval: 30m scrape_timeout: 1m scrape_integration: true account_name: "SNOWFLAKE_ACCOUNT" username: "SNOWFLAKE_USERNAME" password: "SNOWFLAKE_PASSWORD" warehouse: "SNOWFLAKE_WAREHOUSE" role: "ACCOUNTADMIN"
The Snowflake integration installs the following dashboards in your Grafana Cloud instance to help monitor your metrics.
- Snowflake overview
- Snowflake data ownership
Snowflake overview dashboard (1/3).
Snowflake overview dashboard (2/3).
Snowflake overview dashboard (3/3).
Snowflake data ownership dashboard (1/2).
Snowflake data ownership dashboard (2/2).
The Snowflake integration includes the following useful alerts:
|SnowflakeWarnHighLoginFailures||Warning: Large login failure rate.|
|SnowflakeWarnHighComputeCreditUsage||Warning: Compute credit usage is within 20% of the configured limit.|
|SnowflakeCriticalHighComputeCreditUsage||Critical: Compute credit usage is over the configured limit.|
|SnowflakeWarnHighServiceCreditUsage||Warning: Cloud services credit usage is within 20% of the configured limit.|
|SnowflakeCriticalHighServiceCreditUsage||Critical: Compute credit usage is over the configured limit.|
|SnowflakeDown||Warning: Snowflake exporter failed to scrape.|
The following metrics are automatically written to your Grafana Cloud instance by connecting your Snowflake instance through this integration:
# 0.0.1 - January 2023 * Initial release
By connecting your Snowflake instance to Grafana Cloud you might incur charges. To view information on the number of active series that your Grafana Cloud account uses for metrics included in each Cloud tier, see Active series and dpm usage and Cloud tier pricing.