Monitoring Snowflake (public preview)

Supported versions

Instana now supports monitoring the metrics and configuration data for Snowflake 8.33.0.

Configuring

The Instana agent uses the following configuration to connect to the Snowflake account. You can update the configuration in the agent configuration file <agent_install_dir>/etc/instana/configuration.yaml to monitor one or more Snowflake accounts:

com.instana.plugin.snowflake:
  accounts:
    - account: '' # account ID
      url: '' # account url
      user: ''
      password: ''
      role: '' 
      warehouse: '' # default warehouse to run queries to extract metrics
      poll_rate:  # default poll_rate in seconds is 3600
      availabilityZone: ''

To access the ACCOUNT_USAGE schema that the Snowflake sensor uses by default for monitoring account metrics, a user must have a role with the necessary privileges, such as the ACCOUNTADMIN role or a role that is granted by an ACCOUNTADMIN user. You can also create a custom role and grant privileges to access the schema.

Viewing metrics

To view the metrics, complete the following steps:

1. From the navigation menu in the Instana UI, select Infrastructure.
2. On the Map tab, select your Snowflake account.
3. To open the Snowflake account dashboard, click Open Dashboard.

You can view the account dashboard with the following metrics and configuration data.