Continuous Data: Automating Data Ingestion from Cloud Storage into Snowflake

Snowflake 2022    |    Intermediate
  • 11 Videos | 1h 27m 27s
  • Includes Assessment
  • Earns a Badge
The Snowpipe feature allows Snowflake to input micro-batches of data as it becomes available, generally within minutes of the data being added to a stage and submitted for ingestion. In this course, you will implement the auto-ingestion of CSV files from external Snowflake stages located on the AWS and Azure cloud platforms. You will begin by setting up a continuous data ingestion pipeline where the data source is located in an Azure Storage Container. This pipeline will include several components, such as queues, enterprise applications, and storage integrations as well as the permissions required to get these pieces to talk to one another. You will then implement something similar with an Amazon S3 bucket as the source of data. This set-up will involve AWS services such as IAM roles, SNS topics, as well as Snowflake objects such as notification integrations and pipes.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    set up an Azure storage account to serve as an external Snowflake stage
    configure a Snowflake integration to be notified of any file additions to an Azure cloud storage container
    link the Azure and Snowflake resources with a Snowpipe for continuous data ingestion
    test out the auto-ingesting of data from Azure storage into a Snowflake table
    set up an Amazon Web Services (AWS) identity and access management (IAM) role for the ingestion of data into Snowflake
  • create a Snowflake storage integration to set up a Simple Storage Service (S3) bucket as an external stage
    create a Simple Notification Service (SNS) topic and configure the permissions needed for an S3 bucket and Snowflake account
    create a pipe to auto-load data from Amazon S3 into a Snowflake table
    ingest data continuously from S3 into Snowflake
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 1s
    UP NEXT
  • Playable
    2. 
    Configuring an Azure Storage Account
    10m 33s
  • Locked
    3. 
    Creating an Azure Notification Integration
    12m 31s
  • Locked
    4. 
    Integrating Snowflake with Azure
    9m
  • Locked
    5. 
    Streaming Data from Azure
    9m 13s
  • Locked
    6. 
    Creating an AWS IAM Role
    9m 19s
  • Locked
    7. 
    Setting Up an S3 Integration in Snowflake
    10m 23s
  • Locked
    8. 
    Configuring an SNS Topic
    10m 30s
  • Locked
    9. 
    Integrating AWS with Snowflake
    4m 24s
  • Locked
    10. 
    Testing the Integration with AWS
    7m 8s
  • Locked
    11. 
    Course Summary
    2m 25s

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.