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

Projects

Next.js Integration

Snowflake Integration

Categories

Latest Projects