Managing Snowflake: Administering a Snowflake Account

Snowflake 2022    |    Expert
  • 14 Videos | 1h 27m 52s
  • Includes Assessment
  • Earns a Badge
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

  • Playable
    1. 
    Course Overview
    1m 45s
    UP NEXT
  • Playable
    2. 
    Snowflake Parameters
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.