Getting Started with Snowflake: Queries, Dashboards, & Tables

Snowflake    |    Beginner
  • 13 videos | 1h 25m 49s
  • Includes Assessment
  • Earns a Badge
Rating 4.7 of 149 users Rating 4.7 of 149 users (149)
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

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 Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Course Data Loading & Visualization in Power BI: Getting Started
Rating 4.7 of 3 users Rating 4.7 of 3 users (3)
Course Data Loading in Snowflake: Fundamentals of Stages
Rating 4.7 of 50 users Rating 4.7 of 50 users (50)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting Started with Snowflake: Using the Snowflake Data Platform
Rating 4.7 of 400 users Rating 4.7 of 400 users (400)
Course Software Data Analysis: Project Management Metrics
Rating 4.6 of 6408 users Rating 4.6 of 6408 users (6408)
Course Queries in Snowflake: Search Optimization, External Table Partitions, & Views
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)