In this episode, we're going back to our Python on Snowflake playlist in order to learn how to create a new table in our Snowflake database from a SQL statement or query. This ability is key for data engineers because it allows you to do things like execute a difficult or long running query one time, then use the output result table over and over with a huge speed boost. This can be used in your pipelines for speed, or simply to make accessible outputs available to data scientists and analysts. Let's go!

Check out my easy time entry system for your business:
https://system.billzone.com/billzone

Join me on Patreon!
  / mackenziedataengineering  

Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...



Check out some tech (and support my channel!):
https://www.amazon.ca/shop/seanmacken...

Want the code from this video?
http://mackenziemackenzie.com/downloads

For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-...

Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-...

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...

#dataengineering #snowflake #python