Python on Snowflake - How to Use executemany with Lists or Tuples for Parameters Sometimes it is necessary to execute many SQL statements against Snowflake using python, whether you need to insert a lot of data from a list, or from sets of tuples you created. Parameterized queries are the safest way to perform this operation, and the executemany method is great because it can save you a lot of time because you can just prepare one statement and submit your lists with it for execution. This way you can insert, update, or delete many rows at once, using one method, and do not need to use a loop or other method to insert your data. Add this to your Python on Snowflake toolkit! Related Videos: Python on Snowflake - Getting started with the Snowflake Connector for Python https://www.youtube.com/watch?v=i2V9HotNgvA Python on Snowflake: Create and Populate a Database and Retrieve Data https://www.youtube.com/watch?v=yvdwKpm1P7A How to Use write_pandas to Migrate Dataframes into Snowflake Databases https://www.youtube.com/watch?v=JMMp5zvWdxs How to Query Snowflake Data into Pandas Dataframes https://www.youtube.com/watch?v=fGtSH1QEeE4 How to Execute Many SQL Statements from a File Using the Python Connector for Snowflake https://www.youtube.com/watch?v=dlFNbyqPKQk Use Parameters on Snowflake Queries with the Python Connector https://www.youtube.com/watch?v=LuQz3O6jcww How to Use execute_string for Many SQL Statements Using Python on Snowflake https://www.youtube.com/watch?v=9SEwpWKRjEk Python on Snowflake - How to Use executemany with Lists or Tuples for Parameters You are watching this one now! 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/mackenziedata... 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/mackenziedat... 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 For developers looking for a new role, check out: https://www.toptal.com/qKaO2b/worlds-top-talent Needing to hire technical resources for your project? Get the best: https://www.toptal.com/qKaO2b/worlds-top-talent #Snowflake #PythonOnSnowflake #executemany https://www.youtube.com/watch?v=Vp80qMoSqjs