Data Loading in Snowflake: Unloading Data

Snowflake 2022    |    Expert
  • 12 Videos | 1h 13m 51s
  • Includes Assessment
  • Earns a Badge
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

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

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.

YOU MIGHT ALSO LIKE

COURSE AWS SysOps Associate 2021: Storage Management
Likes 6 Likes 6  
COURSE AWS Developer Associate 2021: Storage Services
COURSE Continuous Data: Automating Data Ingestion from Cloud Storage into Snowflake