Managing Snowflake: Administering a Snowflake Account

Snowflake    |    Expert
  • 14 videos | 1h 27m 52s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 31 users Rating 4.4 of 31 users (31)
Snowflake is a powerful enterprise Software as a Service (SaaS) offering, and like all SaaS technologies, it is particularly important to administer it correctly, from the perspective of both security and access control and of monitoring and attributing resource usage. Otherwise, costs and security vulnerabilities can quickly pile up as users, roles, and accounts increasingly multiply. In this course, discover how to manage the accounts and users within an organization. Then, explore how Snowflake allows users to configure various properties on objects, using parameters. Next, use resource monitors to impose limits on the number of credits consumed by Snowflake and examine what happens if that limit is breached. Learn how to configure single sign-on using Otka and implement federated authentication. Finally, perform data masking and investigate how Snowflake allows you to redact and censor data at the column level using masking polices.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Recall account, session, and object parameters
    View accounts and users within an organization
    Create and view a new snowflake account
    View and modify session and account parameters
    Restore parameters and use user-level parameters
    Use object-level parameters
  • Recall how to configure security in snowflake
    Create and use resource monitors
    Set up okta for sso for snowflake
    Implement federated authentication in snowflake using okta
    Set up and use key-pair authentication with snowflake
    Mask numeric and string data using column-level masking policies
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 45s
  • 8m 57s
  • Locked
    3.  Viewing Accounts and Users in an Organization
    6m 49s
  • Locked
    4.  Creating Snowflake Accounts
    7m 44s
  • Locked
    5.  Configuring Parameters in Snowflake
    7m 20s
  • Locked
    6.  Using User-level Parameters in Snowflake
    6m 21s
  • Locked
    7.  Using Object-level Parameters in Snowflake
    3m 51s
  • Locked
    8.  Snowflake Security Configuration
    2m 19s
  • Locked
    9.  Using Resource Monitors in Snowflake
    7m 31s
  • Locked
    10.  Setting up Single Sign-on (SSO) Using Okta
    7m 18s
  • Locked
    11.  Using SSO in Snowflake
    8m 50s
  • Locked
    12.  Using Key Pair Authentication with Snowflake
    6m 54s
  • Locked
    13.  Masking Data in Columns
    8m 26s
  • Locked
    14.  Course Summary
    3m 47s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Microsoft Azure Administrator: Authentication & Authorization
Rating 4.7 of 65 users Rating 4.7 of 65 users (65)
Course Getting Started with Snowflake: Using the Snowflake Data Platform
Rating 4.7 of 400 users Rating 4.7 of 400 users (400)
Course Getting Started with Snowflake: Queries, Dashboards, & Tables
Rating 4.7 of 149 users Rating 4.7 of 149 users (149)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Data Loading in Snowflake: Using External Stages
Rating 4.6 of 32 users Rating 4.6 of 32 users (32)
Course Continuous Data: Ingesting Continuous Data in Snowflake
Rating 4.8 of 33 users Rating 4.8 of 33 users (33)
Course Data Loading in Snowflake: Fundamentals of Stages
Rating 4.7 of 50 users Rating 4.7 of 50 users (50)