Menu

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 SNOWFLAKE.ACCOUNT_USAGE schema.

Refer to the Snowflake documentation for instructions on how to enable other roles to access the SNOWFLAKE.ACCOUNT_USAGE schema.

Install Snowflake integration for Grafana Cloud

  1. In your Grafana Cloud instance, click Integrations and Connections (lightning bolt icon).
  2. Navigate to the Snowflake tile and review the prerequisites. Then click Install integration.
  3. 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:

  • account_name - [organization]-[account] Example: aaaaaaa-bb12345
  • username
  • password
  • warehouse
  • role if the user is not configured with the ACCOUNTADMIN role.

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"

Dashboards

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).

image

Snowflake overview dashboard (2/3).

image

Snowflake overview dashboard (3/3).

image

Snowflake data ownership dashboard (1/2).

image

Snowflake data ownership dashboard (2/2).

image

Alerts

The Snowflake integration includes the following useful alerts:

Group: SnowflakeAlerts

AlertDescription
SnowflakeWarnHighLoginFailuresWarning: Large login failure rate.
SnowflakeWarnHighComputeCreditUsageWarning: Compute credit usage is within 20% of the configured limit.
SnowflakeCriticalHighComputeCreditUsageCritical: Compute credit usage is over the configured limit.
SnowflakeWarnHighServiceCreditUsageWarning: Cloud services credit usage is within 20% of the configured limit.
SnowflakeCriticalHighServiceCreditUsageCritical: Compute credit usage is over the configured limit.
SnowflakeDownWarning: Snowflake exporter failed to scrape.

Metrics

The following metrics are automatically written to your Grafana Cloud instance by connecting your Snowflake instance through this integration:

  • snowflake_auto_clustering_credits
  • snowflake_failed_login_rate
  • snowflake_failsafe_bytes
  • snowflake_login_rate
  • snowflake_stage_bytes
  • snowflake_storage_bytes
  • snowflake_successful_login_rate
  • snowflake_table_active_bytes
  • snowflake_table_clone_bytes
  • snowflake_table_failsafe_bytes
  • snowflake_table_time_travel_bytes
  • snowflake_up
  • snowflake_used_cloud_services_credits
  • snowflake_used_compute_credits
  • snowflake_warehouse_blocked_queries
  • snowflake_warehouse_executed_queries
  • snowflake_warehouse_overloaded_queue_size
  • snowflake_warehouse_provisioning_queue_size
  • snowflake_warehouse_used_cloud_service_credits
  • snowflake_warehouse_used_compute_credits

Changelog

# 0.0.1 - January 2023

* Initial release

Cost

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.