Snowflake Telemetry in Count
Written by The Count Team
Explore Snowflake telemetry with Count's flexible canvas. Visualize query performance, optimize databases, and enhance data insights effortlessly.
Regardless of where your database resides, keeping track of what is happening in the database has long been a challenge for most database administrators, database developers, and business intelligence architects. Databases grow and change over time, which led to the rise of INFORMATION_SCHEMA as part of the ANSI SQL Standard first introduced in SQL-92.
In addition to implementing INFORMATION_SCHEMA in every database that you create in Snowflake, every edition of Snowflake comes with a ‘Snowflake’ database that has a large number of views that provide all kinds of interesting metadata that augment what can be found in INFORMATION_SCHEMA.
Given the wealth of information available in the Snowflake database, what should we do with it? The initial reaction is to build a dashboard with some of the most interesting information. I have never been a huge fan of traditional dashboards. Most tools implement them in a way that makes them restrictive in terms of both presentation and functionality. Building dashboards has always felt like an exercise in trying to make my data fit someone else’s needs.