How to Execute Many SQL Statements on Snowflake with execute_stream
Sometimes you have a bunch of SQL statements that you need to execute on your Snowflake database. You have them already in a string in memory, and just need to execute all of them. You can do this using execute_stream from the Snowflake Connector for Python, which will execute a bunch of these so you don’t have to do a loop or many execute statements of your own. In this demonstration, we’ll execute two statements (each from a different table), then provide their output to see.
Snowflake Project? Contact me today!