Snowflake monitoring integration

To find the queries that take the longest to load:

1. Create a file and name it longest_queries.sql.

2. Designate the file path as newrelic-snowflake-integrations/queries.

3. Add this snippet to the longest_queries.sql file:

   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' 
   ORDER BY 
       execution_time DESC;

   Copy

4. Add this snippet to the flex-snowflake-linux.yml file:

   - name: longestQueries
     entity: snowflake
     # New Relic will capture all your Snowflake metrics when you use `event_type: SnowflakeVirtualWarehouse`.
     event_type: SnowflakeVirtualWarehouse
     custom_attributes:
       metric_type: snowflake.query_performance
     commands:
       - run: YOUR_PATH_TO_DOWNLOADED_BINARY_FILE YOUR_PATH_TO_CLONED_REPOSITORY_DIRECTORY/config.yaml YOUR_PATH_TO_CLONED_REPOSITORY_DIRECTORY/queries/longest_queries.sql

   Copy

To find the queries that take the longest to load:

1. Create a file and name it credit_usage_by_warehouse.sql.

2. Designate the file path as YOUR_PATH_TO_CLONED_REPOSITORY_DIRECTORY/queries/credit_usage_by_warehouse.sql.

3. Add this snippet to the credit_usage_by_warehouse.sql file:

   SELECT 
       warehouse_name, 
       sum(credits_used) AS total_credits_used 
   FROM 
       snowflake.account_usage.warehouse_metering_history 
   GROUP BY 
       1 
   ORDER BY 
       2 DESC;

   Copy

4. Add this snippet to the flex-snowflake.yml file:

   - name: CreditUsageByWarehouse
     entity: snowflake
     event_type: SnowflakeVirtualWarehouse
     custom_attributes:
       metric_type: snowflake.credit_usage_by_warehouse
     commands:
       - run: YOUR_PATH_TO_DOWNLOADED_BINARY_FILE YOUR_PATH_TO_CLONED_REPOSITORY_DIRECTORY/config.yaml YOUR_PATH_TO_CLONED_REPOSITORY_DIRECTORY/queries/credit_usage_by_warehouse.sql

   Copy