Data Loading in Snowflake: Unloading Data

Snowflake    |    Expert
  • 12 videos | 1h 13m 51s
  • Includes Assessment
  • Earns a Badge
Rating 4.8 of 32 users Rating 4.8 of 32 users (32)
Snowflake supports the bulk unloading, or export, of batch data using both internal and external stages. Begin this course by unloading data to all three types of internal stages - user, table, and named. Then, unload data to external stages on the Google Cloud Platform, Microsoft Azure, and Amazon Simple Storage Service (S3). Finally, query data directly from staged files, focusing on the syntax and restrictions of querying data in this manner. When you have completed this course, you will be able to unload data from Snowflake to all three types of internal storage, as well as externally to Google Cloud Storage buckets, Amazon S3 bucket, and Azure Blob Storage.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Recognize how to unload data in snowflake
    Unload data to user stages
    Unload data using table stages
    Unload data in json and parquet formats
    Unload data to google cloud storage buckets
  • Unload data to azure blob storage containers
    Unload data to amazon simple storage service (s3) buckets
    Query files in stages
    Query table and named stages
    Query external stages
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 21s
  • 4m 15s
  • Locked
    3.  Unloading Data in Snowflake to User Stages
    8m 12s
  • Locked
    4.  Unloading Data in Snowflake Using Table Stages
    9m 23s
  • Locked
    5.  Unloading Data in Snowflake to Named Stages
    6m 25s
  • Locked
    6.  Unloading Data in Snowflake to the GCP
    9m 43s
  • Locked
    7.  Unloading Data in Snowflake to Azure
    7m 44s
  • Locked
    8.  Unloading Data in Snowflake to Amazon S3
    4m 23s
  • Locked
    9.  Querying Files in Snowflake Stages
    6m 50s
  • Locked
    10.  Querying Table and Named Stages in Snowflake
    7m 37s
  • Locked
    11.  Querying External Stages in Snowflake
    4m 58s
  • Locked
    12.  Course Summary
    2m 59s

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 Data Loading in Snowflake: Fundamentals of Stages
Rating 4.7 of 50 users Rating 4.7 of 50 users (50)
Course Data Engineering on Microsoft Azure: Data Lake Storage
Rating 4.6 of 43 users Rating 4.6 of 43 users (43)
Course Microsoft Azure Fundamentals: Managing Storage
Rating 4.6 of 423 users Rating 4.6 of 423 users (423)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Queries in Snowflake: Getting Started with Performance Optimizations
Rating 4.6 of 51 users Rating 4.6 of 51 users (51)
Course Getting Started with Snowflake: Queries, Dashboards, & Tables
Rating 4.7 of 149 users Rating 4.7 of 149 users (149)
Course Data Loading in Snowflake: Using External Stages
Rating 4.6 of 32 users Rating 4.6 of 32 users (32)