Python on Snowflake - How to Use executemany with Lists or Tuples for Parameters

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
Python on Snowflake: Create and Populate a Database and Retrieve Data
How to Use write_pandas to Migrate Dataframes into Snowflake Databases
How to Query Snowflake Data into Pandas Dataframes
How to Execute Many SQL Statements from a File Using the Python Connector for Snowflake
Use Parameters on Snowflake Queries with the Python Connector
How to Use execute_string for Many SQL Statements Using Python on Snowflake
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 :

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

For developers looking for a new role, check out:

Want my team to do a project for you? Let's get to it!

#Snowflake #PythonOnSnowflake #executemany

[DeshmukhSachin]

Nice video .. please share video on connection with snowflake to azure and amazon for event and notification

[deejay]

When I use a list I get the error: TypeError: not all arguments converted during string formatting.

[krishnakuraku]

Thank you.. can you please do a video on copy command from local or AWS s3 bucket..

[phugacious]

Thank you so much for the great video and happy Easter to you and your loved ones. I tried executemany method however I got sql-compilation-error because mydb table has 20 columns and I was inserting data for only 6 columns. And yes all non-null columns are included in those 6 columns. Is there any workaround for this? Would you suggest Copy Into statement instead of Insert Into? Thank you again for reading the comment 🙂

[phugacious]

Sorry I just found the solution to my issue. Snowflake-Python-Connector has a method called "write_pandas" and it did the magic. 🙂