Udemy – Snowflake Database – Snowflake Queries to Monitor Snowflake

What you’ll 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
Requirements
Some basic experience with Snowflake would be useful
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.
Who this course is for
All levels of Snowflake administrators and developers who need to monitor some aspect of their Snowflake environment will find this course useful
Homepage

https://www.udemy.com/course/snowflake-database-snowflake-queries-to-monitor-snowflake/

 

 

Download From hot4share.com

++++++++++++++++++++++++++