New Relic Snowflake integration

GitHub - for the full source code

This project started as an open source contribution to the New Relic community and thanks to its popularity is now a Community Plus project supported by New Relic.

It is a New Relic integration with Snowflake to monitor query performance, logins, potential security incidents, optimise warehouse and cloud credit costs, capture any data stored in Snowflake for real-time alerting and reporting. It comes with out of the box queries to capture a good range of performance related metrics. It is easily extendible to create custom queries to capture any other metrics that are not covered by default.

Main features

• Out of the box queries to capture:
  • account metrics
  • automatic clustering usage
  • credit usage by warehouse
  • data transfer usage
  • storage usage
  • login history
  • longest quries
  • pipe usage
  • query history
  • replication usage
  • stage storage usage
  • werehouse load history
  • werehouse metering
• Yaml configuration file to easily set up the integration
  • with obfuscation of sensitive data
  • supports authentication
    • with username and password
    • with OAuth
• Releases for Windows, Linux and Mac
• Extensible to create custom queries

Libraries and tools used

• Snowflake JS SDK - to connect to Snowflake
• NR Flex - to create the integration
• GitHub Actions - to build and release the integration as a binary for multiple platforms