Snowflake Database - Snowflake Queries to Monitor Snowflake

Description

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.

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
• Longest running queries
• Blocked queries
• Virtual warehouse usage and credit consumption
• Large partition scan queries
• Data Transfers and ingestion

Who Should Attend!

• All levels of Snowflake administrators and developers who need to monitor some aspect of their Snowflake environment will find this course useful

TAKE THIS COURSE