SNOW-1367466: pd_writer throwing : not all arguments converted during string formatting

[mhasan09]

Python version

3.10.7

Operating system and processor architecture

windows 11

Installed packages

SQLAlchemy==1.4.52
snowflake-sqlalchemy==1.5.3
snowflake-connector-python==3.10.0
pandas==2.2.2

What did you do?

engine = create_engine(url)
loan_file = "loan_9.csv"
df = pd.read_csv(loan_file, sep=",", header=0, index_col=False)
with engine.connect() as con:
    df.to_sql(name='LOAN_PAYMENT', con=con.connection, index=False, method=pd_writer, if_exists='append')

What did you expect to see?

Expected the example to work, but got

Execution failed on sql '
        SELECT
            name
        FROM
            sqlite_master
        WHERE
            type IN ('table', 'view')
            AND name=?;
        ': not all arguments converted during string formatting

[sfc-gh-sghosh]

Hello @mhasan09 ,

Thank you for raising the issue, we are looking into it, will update.

Regards,
Sujan

[sfc-gh-sghosh]

Hello @mhasan09 ,

We tried to reproduce it with below code snippet, but its not throwing above error, its working fine.

using below versions

import sqlalchemy
print(sqlalchemy.version)
import snowflake.sqlalchemy
print(snowflake.sqlalchemy.version)

1.4.52
1.5.3

`from sqlalchemy import create_engine
import pandas as pd

Load your CSV data into a DataFrame

loan_file = "File1.csv"
df = pd.read_csv(loan_file, sep=",", header=0, index_col=False)

engine = create_engine(URL(
account = 'xxxx',
user = 'xxx',
password = 'xxx',
database = 'SAMPLEDATABASE',
schema = 'TEST',
warehouse = 'SUJAN_WH',
role='xxxx',
))

try:
connection = engine.connect()
results = connection.execute('select current_version()').fetchone()
print(results[0])

Write the DataFrame to Snowflake using SQLAlchemy

with engine.connect() as con:
    df.to_sql(name='mycsvtable2', con=con, index=False, if_exists='append')

finally:
connection.close()
engine.dispose()`

Its writing to table perfectly

Regards,
Sujan