Data Engineering Project Part 2 - Inserting And Parsing JSON Into Snowflake

Finally, part 2 is here. For this video we will be focusing Snowflake.

We will use Snowflake Stages and Tasks to automate the data we have pulled into S3.

If you haven't watched the first data engineering project video, then check out the link below https://www.youtube.com/watch?v=pi37QN-2Ugw

Here is a git gist of the SQL https://gist.github.com/bAcheron/b9bc5c17d2c120be3f3bee48abeefe0d

Also, here is how to create a snowflake integration to s3 https://docs.snowflake.com/en/user-guide/data-load-s3-config-storage-integration.html

If you enjoyed this video, check out some of my other top videos.

Top Courses To Become A Data Engineer In 2022 https://www.youtube.com/watch?v=kW8_l57w74g

What Is The Modern Data Stack - Intro To Data Infrastructure Part 1 https://www.youtube.com/watch?v=-ClWgwC0Sbw

If you would like to learn more about data engineering, then check out Googles GCP certificate https://bit.ly/3NQVn7V

If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.

https://seattledataguy.substack.com/​​

Or check out my blog https://www.theseattledataguy.com/

And if you want to support the channel, then you can become a paid member of my newsletter https://seattledataguy.substack.com/subscribe

Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio

Subscribe: https://www.youtube.com/channel/UCmLGJ3VYBcfRaWbP6JLJcpA?sub_confirmation=1

About me: I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consult on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data.

I do participate in affiliate programs, if a link has an "" by it, then I may receive a small portion of the proceeds at no extra cost to you. ... https://www.youtube.com/watch?v=PhHZ7JXvtug