Python on Snowflake - How to use execute_async to kick off one/more queries - No stopping the code!

Python on Snowflake - How to use execute_async to kick off one/more queries - No stopping the code! 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! Related Videos: Python on Snowflake: 1 Million Record Migration from SQL Server using read_sql and write_pandas https://youtu.be/FHQyOlcO3RQ Python on Snowflake - How to use execute_async to kick off one/more queries - No stopping the code! You are watching this one now! How to Use SQL Joins when Using Python on Snowflake to Get Pandas Dataframes https://youtu.be/n3MmuEjLuzM How to Use Python to Create Stored Procedures in Snowflake - SQL, Javascript, and Python Example https://youtu.be/bKQgTnjbeaM Python on Snowflake - How to Perform Transactions with Rollback https://youtu.be/Kx_rMTz-TTQ Python on Snowflake - How to Perform Concurrent Select Queries Using execute_async https://youtu.be/KNdgCnJCE7Y Python on Snowflake - How to Use Describe() https://youtu.be/DNzc-ifhSmQ Python on Snowflake: How to use Merge (Upsert) https://youtu.be/aqZ8c4cc_9w Python on Snowflake - How to Read and Write JSON Data Part 1 https://youtu.be/-8D0l3-Qu-s Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering Interested in transforming your career or finding your next gig? https://system.billzone.com/careers.html Want my team to do a project for you? Let's get to it! https://buy.billzone.com/smdeprojects.html #PythonSnowflake #Snowflake #execute_async https://youtu.be/DMVmpNyhF5g