Monitoring Snowflake

After you install the Instana agent, the Snowflake sensor is automatically installed and deployed. You can view metrics that are related to the Snowflake sensor in the Instana UI.

Support information

To make sure that the Snowflake sensor is compatible with your current setup, check the following support information sections:

Supported versions and support policy

The sensor supports Snowflake 8.39.2.

The following table shows the latest supported version and support policy:

Table 1. Latest supported version and support policy
Technology Support policy Latest version Latest supported version
Snowflake On demand 8.40 8.39.2

For more information about the support policy, see Support strategy for sensors.

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
      collectOrganizationData:  # default collectOrganizationData is false
      org_poll_rate: # default org_poll_rate in seconds is 43200
      availabilityZone: 'Snowflake Instance Monitoring'

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.

Notes:
  • Enable organization data collection for at least one account within the organization.
  • You can enable organization data collection for two accounts within the same organization. However, this approach is not suggested because the collection method is the same for both accounts.
  • You can enable organization data collection for multiple accounts across different organizations, depending on your requirements.

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.

Monitoring Account Usage

Configuration data

You can view the following configuration data on the dashboard:

  • Account locator
  • Account name
  • Organization
  • Region
  • Version

Key performance indicators

The following table outlines the key indicators for the Snowflake sensor:

Data point Description Granularity
Hourly Credit Usage Total credit usage of the account per hour. 1 hour
Storage Bytes Total storage bytes that are used in the past 24 hours. 1 hour
Query Executed Count Total number of queries that are executed in the past 24 hours. 1 hour
Bytes Scanned Average number of bytes that are scanned for query execution in the past 24 hours. 1 hour

Account usage metrics

The following table outlines the metrics for the Snowflake sensor:

Data point Description Granularity
Warehouse Credit Usage Credits consumed by each warehouse over time
- Compute Credits: Total number of credits that were used for the warehouse in the past 24 hours.
- Cloud Services Credits: Total number of credits that were used for cloud services in the past 24 hours.
- Total Credits: Total number of credits that were used for the warehouse in the past 24 hours.		 1 hour
Average Bytes Spilled to Local Storage Average number of bytes that were written to the local storage in the past 24 hours. 1 hour
Average Bytes Spilled to Remote Storage Average number of bytes that were written to the remote storage in the past 24 hours. 1 hour
Longest Running Queries List of top 10 queries with the highest execution time in the past 24 hours. 1 hour
Storage, Stage and Failsafe Bytes Total number of storage, stage, and failsafe bytes in the past 24 hours. 1 hour
Login Attempts Total number of successful and failed login attempts in the past 24 hours. 1 hour

Due to additional costs from background services, concurrency scaling, storage, and other factors total credits usage might differ from the sum of compute credits and cloud services credits.

Monitoring Organization Usage

Configuration data

You can view the configuration data of the organization on the dashboard.

Organization Key Performance Indicators (KPIs)

The following table outlines the organizational KPIs for the Snowflake sensor:

Data point Description
Overall Credit Usage Total number of credits consumed across all accounts in the organization.
Total Storage Bytes Total amount of storage used, including both database and stage storage.
Usage in Currency Total cost incurred, based on the credit and storage usage.

Organization usage metrics

The following table outlines the organizational metrics for the Snowflake sensor:

Data point Description
Top 5 Billing Accounts Details of the top 5 billing accounts, including account names and credit usage information.
Remaining Balance in currency The amount of available capacity in currency, reflecting the remaining balance for use as of the date