With our Snowflake dashboard, you can easily monitor the health of your storage systems and warehouses, track query performance, and get a total overview of potential security incidents.
Built with our infrastructure agent, the Snowflake integration gives you a set of pre-built that let you view your most critical query data, all in one place.
After setting up the Snowflake integration with New Relic, see your data in dashboards like these, right out of the box.
Install the infrastructure agent
To see your Snowflake data in New Relic, install our infrastructure agent. The infrastructure agent collects data from Snowflake and sends that data to New Relic, where you can use performance metrics dashboards to keep track of how your Snowflake storage system is doing.
There are two methods to install the infrastructure agent:
Follow our guided install to instrument your system with the infrastructure agent.
To ensure you're using the most recent information for the integration, update your config.yaml file so that the file matches the snippet found in Snowflake's Key Pair authentication section.
Set the NEWRELIC_SNOWFLAKE_HOME environment variable as documented in the Setting NEWRELIC_SNOWFLAKE_HOME section. Skip this step if you're running the New Relic infrastructure agent as a systemd service and followed the alternative step for this.
Copy the relevant flex config for your platform from flexConfigs to the agent's integrations.d folder:
for Linux, find it at /etc/newrelic-infra/integrations.d/
for Windows, find it at C:\Program Files\New Relic\newrelic-infra\integrations.d\.
Once you've followed all these steps, return to this doc to install the to your New Relic account.
Create custom queries
You can send your own customized metrics to New Relic. Once you've added these custom queries, you can monitor them on a dashboard.
Below are two examples of custom queries.
To find the queries that take the longest to load:
Create a file and name it longest_queries.sql
Designate the file path as newrelic-snowflake-integrations/queries.
In longest_queries.sql, add the following snippet:
select
query_id,
query_text,
(execution_time /60000)as exec_time,
warehouse_name,
user_name,
execution_status
from
snowflake.account_usage.query_history
where
execution_status ='SUCCESS'
orderby
execution_time desc
In the flex-snowflake-linux.yml file, add the following snippet:
-name: longestQueries
entity: snowflake
# New Relic will capture all your Snowflake metrics when you use `event_type: SnowflakeVirtualWarehouse`.