How to Use execute_async to Start Queries without Waiting for Results

23-October-2021
Sometimes we don’t want to wait! In this episode, we take a look at how to run queries asynchronously on our Snowflake database by using execute_async. This method allows us to “kick off” several (non-dependent) queries at the same time, creating some nice efficiencies in our programming. Not having to wait allows us to perform a bunch of updates, inserts, and deletes at the same time (when we know they are not dependent on each other), and also perform more than one select if we need to. Let’s get to our execute_async on Snowflake with Python!



Snowflake Project? Contact me today!