Snowflake Database - Snowflake Queries to Monitor Snowflake

Snowflake Database - Snowflake Queries to Monitor Snowflake

Snowflake was written from the ground up to be a novel and advanced cloud data platform provided as Software-as-a-Service (SaaS). Snowflake enables data storage, processing, and analytic solutions that are faster, easier to use, and far more flexible than traditional offerings.

One of the most important activities any Snowflake administrator has to perform, or any developer who has been given the responsibility of monitoring the Snowflake environment, is knowing how to actually monitor Snowflake, and what support is available in the Snowflake SQL language to monitor the environment.

Of course, some aspects of Snowflake can be monitored via the Web UI. But there is a whole host of views and table functions available to monitor your entire Snowflake account. That is the focus of this course.

This course demonstrates how to create queries (several dozen in total) to monitor all the major areas of Snowflake including role-based access, users and logins, virtual warehouse usage and credit consumption and many miscellaneous queries to monitor Snowflake activity.

When you complete this course you will have a suite of queries to monitor virtual warehouse usage, credit spending, monitoring ingestion with COPY INTO and Snowpipe, users and logins, long running queries, blocked queries and much more.

Over two dozen queries that enable you to monitor all aspects of Snowflake

Url: View Details

What you will learn

• Queries to monitor all aspects of role-based access
• Queries to monitor users, logins, failed login and failed login rates
• Long running queries

Rating: 4.75

Level: All Levels

Duration: 3 hours

Instructor: Randy Minder