Getting Started with Snowflake: Queries, Dashboards, & Tables

Snowflake 2022    |    Beginner
  • 13 Videos | 1h 25m 49s
  • Includes Assessment
  • Earns a Badge
Scanning an entire table to return output for a single query is computationally intensive, so many technologies rely on partitioning tables to improve query performance for big data. Snowflake implements a form of partitioning known as micro-partitioning where all tables are automatically divided into micro-partitions that users don't need to manage. In this course, explore and execute queries using Snowflake's web interface, Snowsight. Next, learn how to create dashboards in Snowsight and add various charts. Finally, discover how permanent, temporary, and transient tables in Snowflake differ and how such tables can be created, used, and cloned. Upon completion, you'll be able to view database objects in Snowsight, run queries and build dashboards, and differentiate the types of Snowflake tables.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    use the Snowsight UI
    create databases and warehouses from Snowsight
    execute queries and view the output
    run various queries
    use daterange and datebucket to interactively query dates
    add visualizations to dashboards
  • recall how partitioning and clustering work
    differentiate permanent, temporary, and transient tables
    use permanent and temporary tables
    utilize temporary and transient tables
    use transient tables
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 7s
    UP NEXT
  • Playable
    2. 
    Using Snowsight
    6m 58s
  • Locked
    3. 
    Creating Objects from Snowsight
    8m 51s
  • Locked
    4. 
    Viewing the Output of Snowsight Queries
    6m 8s
  • Locked
    5. 
    Running Various Queries
    7m 22s
  • Locked
    6. 
    Using daterange and datebucket
    4m 57s
  • Locked
    7. 
    Adding Visualizations to Dashboards
    9m 25s
  • Locked
    8. 
    Partitioning and Clustering
    8m 50s
  • Locked
    9. 
    Types of Tables in Snowflake
    4m 59s
  • Locked
    10. 
    Using Permanent and Temporary Tables
    10m 3s
  • Locked
    11. 
    Utilizing Temporary Tables
    5m 21s
  • Locked
    12. 
    Using Transient Tables
    8m 10s
  • Locked
    13. 
    Course Summary
    3m 39s

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.