Snowflake integration for Grafana Cloud

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 SNOWFLAKE.ACCOUNT_USAGE schema. See 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 stack, click Connections in the left-hand menu.
2. Find Snowflake and click its tile to open the integration.
3. Review the prerequisites in the Configuration Details tab and set up Grafana Agent to send Snowflake metrics to your Grafana Cloud instance.
4. 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.

Configuration snippets for Grafana Alloy

Simple mode

These snippets are configured to scrape a single Snowflake instance running locally with default ports.

Copy and paste the following snippets into your Grafana Alloy configuration file.

Integrations snippets

river Copy

prometheus.exporter.snowflake "integrations_snowflake" {
	account_name = "SNOWFLAKE_ACCOUNT"
	username     = "SNOWFLAKE_USERNAME"
	password     = "SNOWFLAKE_PASSWORD"
	warehouse    = "SNOWFLAKE_WAREHOUSE"
}

discovery.relabel "integrations_snowflake" {
	targets = prometheus.exporter.snowflake.integrations_snowflake.targets

	rule {
		target_label = "instance"
		replacement  = constants.hostname
	}

	rule {
		target_label = "job"
		replacement  = "integrations/snowflake"
	}
}

prometheus.scrape "integrations_snowflake" {
	targets         = discovery.relabel.integrations_snowflake.output
	forward_to      = [prometheus.remote_write.metrics_service.receiver]
	job_name        = "integrations/snowflake"
	scrape_interval = "30m0s"
	scrape_timeout  = "1m0s"
}

Advanced mode

The following snippets provide examples to guide you through the configuration process.

To instruct Grafana Alloy to scrape your Snowflake instances, copy and paste the snippets to your configuration file and follow subsequent instructions.

Advanced integrations snippets

river Copy

prometheus.exporter.snowflake "integrations_snowflake" {
	account_name = "SNOWFLAKE_ACCOUNT"
	username     = "SNOWFLAKE_USERNAME"
	password     = "SNOWFLAKE_PASSWORD"
	warehouse    = "SNOWFLAKE_WAREHOUSE"
}

discovery.relabel "integrations_snowflake" {
	targets = prometheus.exporter.snowflake.integrations_snowflake.targets

	rule {
		target_label = "instance"
		replacement  = constants.hostname
	}

	rule {
		target_label = "job"
		replacement  = "integrations/snowflake"
	}
}

prometheus.scrape "integrations_snowflake" {
	targets         = discovery.relabel.integrations_snowflake.output
	forward_to      = [prometheus.remote_write.metrics_service.receiver]
	job_name        = "integrations/snowflake"
	scrape_interval = "30m0s"
	scrape_timeout  = "1m0s"
}

This integrations uses the prometheus.exporter.snowflake component to generate metrics from a Snowflake instance.

You must provide account details and credentials to scrape snowflake, including the account_name (in the form of [organization]-[account], e.g. aaaaaaa-bb12345), username, password, warehouse, and role if the user is not configured with the ACCOUNTADMIN role.

For the full array of configuration options, refer to the prometheus.exporter.snowflake component reference documentation.

This exporter must be linked with a discovery.relabel component to apply the necessary relabelings.

For each Snowflake instance to be monitored you must create a pair of these components.

Configure the following properties within each discovery.relabel component:

• instance label: constants.hostname sets the instance label to your Grafana Alloy server hostname. If that is not suitable, change it to a value uniquely identifies this Snowflake instance.

You can then scrape them by including each discovery.relabel under targets within the prometheus.scrape component.

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.

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 SNOWFLAKE.ACCOUNT_USAGE schema. See 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 stack, click Connections in the left-hand menu.
2. Find Snowflake and click its tile to open the integration.
3. Review the prerequisites in the Configuration Details tab and set up Grafana Agent to send Snowflake metrics to your Grafana Cloud instance.
4. 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 [organization]-[account], e.g. aaaaaaa-bb12345), username, password, warehouse, and 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, 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

Below integrations, insert the following lines and change the URLs according to your environment:

yaml Copy

  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.

yaml Copy

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_sync_length_seconds_sum|prometheus_target_scrapes_.*|prometheus_target_interval.*|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