Snowflake integration for Grafana Cloud
Snowflake is a cloud data platform that is designed to connect businesses globally, across any type or scale of data and many different workloads, 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. Accompanying dashboards are provided to visualize these metrics.
This integration supports metrics provided by v0.0.1 of the Snowflake exporter, which is integrated into the Grafana Agent.
This integration includes 6 useful alerts and 2 pre-built dashboards to help monitor and visualize Snowflake metrics.
Before you begin
In order to scrape Snowflake metrics, you must use a user configured with the
ACCOUNTADMIN role, or a custom role that has access to the
See the Snowflake documentation for instructions on how to enable other roles to access the
Install Snowflake integration for Grafana Cloud
- In your Grafana Cloud stack, click Connections in the left-hand menu.
- Find Snowflake and click its tile to open the integration.
- Review the prerequisites in the Configuration Details tab and set up Grafana Agent to send Snowflake metrics to your Grafana Cloud instance.
- Click Install to add this integration’s pre-built dashboards and alerts to your Grafana Cloud instance, and you can start monitoring your Snowflake setup.
Post-install configuration for the Snowflake integration
This integration is configured to work with the
snowflake-prometheus-exporter, which is embedded in Grafana Agent.
Enable the integration by adding the provided snippet to your agent configuration file.
In the agent configuration file, you must provide account details and credentials to scrape snowflake, including the
account_name (in the form of
role if 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, but this interval may be reduced if desired.
For a full description of configuration options see how to configure the
snowflake block in the agent documentation.
Configuration snippets for Grafana Agent
integrations, insert the following lines and change the URLs according to your environment:
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" relabel_configs: - replacement: '<your-instance-name>' target_label: instance
Full example configuration for Grafana Agent
Refer to the following Grafana Agent configuration for a complete example that contains all the snippets used for the Snowflake integration. This example also includes metrics that are sent to monitor your Grafana Agent instance.
integrations: prometheus_remote_write: - basic_auth: password: <your_prom_pass> username: <your_prom_user> url: <your_prom_url> agent: enabled: true relabel_configs: - action: replace source_labels: - agent_hostname target_label: instance - action: replace target_label: job replacement: "integrations/agent-check" metric_relabel_configs: - action: keep regex: (prometheus_target_.*|prometheus_sd_discovered_targets|agent_build.*|agent_wal_samples_appended_total|process_start_time_seconds) source_labels: - __name__ # Add here any snippet that belongs to the `integrations` section. # For a correct indentation, paste snippets copied from Grafana Cloud at the beginning of the line. 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" relabel_configs: - replacement: '<your-instance-name>' target_label: instance logs: configs: - clients: - basic_auth: password: <your_loki_pass> username: <your_loki_user> url: <your_loki_url> name: integrations positions: filename: /tmp/positions.yaml scrape_configs: # Add here any snippet that belongs to the `logs.configs.scrape_configs` section. # For a correct indentation, paste snippets copied from Grafana Cloud at the beginning of the line. metrics: configs: - name: integrations remote_write: - basic_auth: password: <your_prom_pass> username: <your_prom_user> url: <your_prom_url> scrape_configs: # Add here any snippet that belongs to the `metrics.configs.scrape_configs` section. # For a correct indentation, paste snippets copied from Grafana Cloud at the beginning of the line. global: scrape_interval: 60s wal_directory: /tmp/grafana-agent-wal
The Snowflake integration installs the following dashboards in your Grafana Cloud instance to help monitor your system.
- Snowflake data ownership
- Snowflake overview
Snowflake overview dashboard (1/3).
Snowflake overview dashboard (2/3).
Snowflake overview dashboard (3/3).
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 most important metrics provided by the Snowflake integration, which are used on the pre-built dashboards and Prometheus alerts, are as follows:
# 0.0.2 - September 2023 * New Filter Metrics option for configuring the Grafana Agent, which saves on metrics cost by dropping any metric not used by this integration. Beware that anything custom built using metrics that are not on the snippet will stop working. * New hostname relabel option, which applies the instance name you write on the text box to the Grafana Agent configuration snippets, making it easier and less error prone to configure this mandatory label. # 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.