|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/snowflake-database-snowflake-queries-to-monitor-snowflake/
课程评论：没有评论
**课程名称：** Snowflake 数据库 - Snowflake 查询用于监控 Snowflake **课程概述：** 本课程是关于如何使用 Snowflake SQL 查询来监控 Snowflake 数据平台的。Snowflake 是一个为云数据设计的、创新的、先进的 SaaS 平台，提供比传统方案更快、更易用、更灵活的数据存储、处理和分析解决方案。 对于 Snowflake 管理员或负责监控 Snowflake 环境的开发人员来说，了解如何有效地监控是至关重要的。虽然 Snowflake 的 Web UI 提供了一些监控功能，但 Snowflake SQL 语言提供了大量的视图和表函数，可用于全面监控整个 Snowflake 账户。本课程的重点就涵盖了这些 SQL 监控能力。 **课程内容亮点：** * **多种监控查询：** 课程将演示如何创建几十个 SQL 查询，用于监控 Snowflake 的各个主要方面。 * **全面监控领域：** 涵盖的监控领域包括： * 基于角色的访问控制 * 用户和登录活动 * 虚拟仓库的使用情况和积分消耗 * COPY INTO 和 Snowpipe 的数据摄取监控 * 长时间运行的查询 * 被阻塞的查询 * 以及其他多种用于监控 Snowflake 活动的杂项查询。 * **实用的查询套件：** 完成课程后，您将掌握一套实用的查询，能够有效地监控您的 Snowflake 环境。 **学习目标：** 完成本课程后，您将能够： * 运用 Snowflake SQL 查询来监控虚拟仓库的使用情况和成本。 * 监控数据摄取过程，包括 COPY INTO 和 Snowpipe。 * 追踪用户登录和会话信息。 * 识别和分析长时间运行或被阻塞的查询。 * 全面了解和监控您的 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.
