Snowflake: Load Data from an s3 bucket (Frosty Friday Week 1)
Автор: Down to Earth Data Tips
Загружено: 2022-07-30
Просмотров: 580
Learn how to Load Data from an s3 bucket in #Snowflake with the new Frosty Friday challenge!
Here is the link to the challenge: https://frostyfriday.org/2022/07/14/w...
If you just wanna see the solution, please go to minute 7:30. The rest of the video shows how I got to the solution through a bit of trial and error following Snowflake documentation.
Timestamps:
0:00 Intro
01:21 Create a File Format in Snowflake
02:21 Create a Named Stage Object in Snowflake
03:19 Copy Data into a Table from a Stage in Snowflake
05:32 Query Metadata from a file in a Stage in Snowflake
7:30 How to Load Data from an s3 Bucket in Snowflake
Useful links:
Tutorial: Bulk Loading from Amazon S3 Using COPY: https://docs.snowflake.com/en/user-gu...
Query Metadata from Staged Files: https://docs.snowflake.com/en/user-gu...
#frostyfriday #snowflake
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: