Load data from AWS S3 to Snowflake Worksheet with SQL

Published: 29 March 2023
on channel: Data Science Garage
1,225
24

This tutorial demonstrates how to efficiently load and query data from AWS S3 bucket to your Snowflake worksheet. This video is dedicated to Snowflake beginners who want to try Snowflake for the first time and has no any previously experience on this technology.

Main take-aways from this tutorial, you will learn how to:
create new Snowflake worksheet.
create and understand what is staging area (staging table).
write SQL queries in Snowflake worksheet.
create IAM user in AWS and assign S3 Full access privileges.
get and use IAM user credentials (AWS ACCESS ID and AWS SECRET KEY)
load data from S3 bucket to Snowflake SQL table.

From the data science perspective, Snowflake was designed from the ground-up to support Machine Learning (ML) and AI-driven data science applications.

With Snowflake you can build apps, data pipelines and design ML workflows.
Official website for developers: https://developers.snowflake.com/

In conjunction with tight integration to Spark, R, Python and other programming languages and frameworks, Snowflake is indispensable data science technology.
One of the main reason is that performance speed is a key factor in supporting robust ML models.

Additional features that Snowflake supports:
SQL API.
External tables.
Iceberg tables.
External functions.
SQL stored procedures.
Native app framework.
Continuous data pipelines.
Streams and tasks.
Separation of compute and storage.
Workload isolation.
Semi-structured data.
Unstructured data.
Connectors and drivers.
Time travel (easily restore and analyze deleted or modified historical data without backups).
Access controls and encryption.
You can check for all features here: https://docs.snowflake.com/en/

Happy learning!

#snowflake #aws #sql


Watch video Load data from AWS S3 to Snowflake Worksheet with SQL online without registration, duration hours minute second in high quality. This video was added by user Data Science Garage 29 March 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,225 once and liked it 24 people.