Data Loading in Snowflake: Using External Stages

Snowflake 2022    |    Expert
  • 15 Videos | 1h 33m 28s
  • Includes Assessment
  • Earns a Badge
Snowflake can load data from the Google Cloud Platform (GCP), Microsoft Azure, and Amazon Simple Storage Service (S3) using external stages. Each cloud platform has one or more techniques for integrating with Snowflake. One method of integration that is supported across all three of the major cloud platforms is storage integration objects. Begin this course by loading data from Google Cloud Storage buckets. Create a Snowflake storage integration object and a GCP cloud storage service account for your Snowflake account. Then, load data from Azure Blob Storage using both the storage integration method and the SAS token method. Finally, integrate with Amazon S3 via storage integrations and using an access key and access key ID credentials. When you have completed this course, you will be able to easily integrate Snowflake with Google Cloud Storage, Azure Blob Storage, and Amazon S3.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    recall how external stages work in Snowflake
    recall how to integrate Snowflake with Google Cloud Platform (GCP)
    create a GCS bucket
    configure GCP permissions
    query data in GCS from Snowflake
    recall how to integrate Snowflake with Azure
    set up Azure Blob Storage
  • integrate Azure Blob Storage with Snowflake
    recall how to integrate with Amazon Simple Storage Service (S3)
    set up an Amazon S3 bucket
    connect to Amazon S3 from Snowflake
    connect to Amazon S3 using access keys
    create and use external tables
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 36s
    UP NEXT
  • Playable
    2. 
    Bulk Loading in Snowflake from Cloud Platforms
    3m 9s
  • Locked
    3. 
    Bulk Loading in Snowflake from Google Cloud Storage
    3m 24s
  • Locked
    4. 
    Creating a Google Cloud Storage (GCS) Bucket
    7m 40s
  • Locked
    5. 
    Setting up a GCP Integration
    7m 47s
  • Locked
    6. 
    Connecting to GCS from Snowflake
    6m 20s
  • Locked
    7. 
    Bulk Loading in Snowflake from Microsoft Azure
    5m
  • Locked
    8. 
    Configuring an Azure Storage Account
    8m 28s
  • Locked
    9. 
    Integrating Blob Storage with Snowflake
    6m 31s
  • Locked
    10. 
    Bulk Loading in Snowflake from Amazon S3
    4m 20s
  • Locked
    11. 
    Setting up Amazon S3
    5m 53s
  • Locked
    12. 
    Integrating with Amazon S3 from Snowflake
    10m 37s
  • Locked
    13. 
    Connecting Snowflake to Amazon S3 Using Access Keys
    6m 52s
  • Locked
    14. 
    Using External Tables in Snowflake
    11m 24s
  • Locked
    15. 
    Course Summary
    4m 29s

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.