Snowflake receiver 🔗

The Snowflake receiver collects metrics from a Snowflake account by connecting to and querying a Snowflake deployment.

Get started 🔗

Follow these steps to configure and activate the component:

Deploy the Splunk Distribution of the OpenTelemetry Collector to your host or container platform:
Configure the receiver as described in the next section.
Restart the Collector.

Sample configuration 🔗

To activate the receiver in the Collector, add snowflake to the receivers section of your configuration file, as shown in the following example:

receivers:
  snowflake:

To complete the configuration, include the receiver in the metrics pipeline of the service section of your configuration file. For example:

service:
  pipelines:
    metrics:
      receivers: [snowflake]

Configuration example 🔗

See the following config example:

receivers:
  snowflake:
    username: snowflakeuser
    password: securepassword
    account: bigbusinessaccount
    warehouse: metricWarehouse
    collection_interval: 5m
    metrics:
      snowflake.database.bytes_scanned.avg:
        enabled: true
      snowflake.query.bytes_deleted.avg:
        enabled: false

Configuration settings 🔗

The following settings are required:

account. No default. Specifies the account from which metrics are gathered from.
password. No default. Specifies the password associated with the designated username. Used to authenticate with Snowflake.
username. No default. Specifies the username used to authenticate with Snowflake.
warehouse. No default. Specifies the warehouse, or unit of computer, designated for the metric gathering queries. Must be an existing warehouse in your Snowflake account.

The following settings are optional:

collection_interval. 30m by default. Collection interval for the metrics receiver. The value for this setting must be readable by golang’s time.ParseDuration. Learn more at GO’s time ParseDuration .
database. 'SNOWFLAKE by default. Snowflake DB containing the schema with usage statistics and metadata to be monitored.
metrics. Controls the enabling/disabling of specific metrics. For a list of available metrics see Metrics. To learn more refer to Snowflake generated metrics in GitHub.
role. 'ACCOUNTADMIN' by default. Role associated with the username designated above. By default you need admin privileges to access most/all of the usage data.
schema. 'ACCOUNT_USAGE' by default. The Snowflake DB schema that contains the usage statistics and metadata to be monitored.

Settings 🔗

The following table shows the configuration options for the Snowflake receiver:

Metrics 🔗

The following metrics, resource attributes, and attributes are available.

Troubleshooting 🔗

If you are a Splunk Observability Cloud customer and are not able to see your data in Splunk Observability Cloud, you can get help in the following ways.

Available to Splunk Observability Cloud customers

Submit a case in the Splunk Support Portal .
Contact Splunk Support .

Available to prospective customers and free trial users

Ask a question and get answers through community support at Splunk Answers .
Join the Splunk #observability user group Slack channel to communicate with customers, partners, and Splunk employees worldwide. To join, see Chat groups in the Get Started with Splunk Community manual.

This page was last updated on Feb 11, 2025.

Related Topics