Snowflake: Load Metadata into a Table (Based on a Condition) - Frosty Friday Week 3
Learn how to load metadata from an s3 bucket into a table in Snowflake based on data contained in another table! If you are interested in the solution only, please skip to 14:54
If you are interested in seeing my thought process, here are the timestamps for the whole video :)
00:00 Intro
00:13 Snowflake Frosty Friday Week 3 Assignment
01:36: Create File Format and Stage in Snowflake
01:58 Query Metadata from an s3 Bucket in Snowflake
03:38 Load Metadata into a Table in Snowflake (Keywords)
06:67 Use SPLIT_PART()
08:04 Load Metadata into a Table in Snowflake (Main Table)
09:55 Filter Metadata in Table Based on Condition
14:54 Load Metadata into a Table Based on a Condition (Solution)
Here is the link to the Frosty Friday Week 3 Challenge: https://frostyfriday.org/2022/07/15/w...
Find the code on my Github: https://github.com/DownToEarthDataTip...
#frostyfriday #snowflake