You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Usingthewrite_pandas() function, Iampassing"overwrite=True", butwith"auto_create_table=False".
Observation:
Thefunctionperformsa"CREATE TABLE IF NOT EXISTS". Thetabledoesexist, andtheschemaismaintainedexternally. ThismeanstheuserIamusingneedstobegranted"CREATE TABLE"privilegesonthetable'sschema.
Possiblesolution:
Switchingtheconditionalonline356ofpandas_tools.pyasfollowswouldprobablysolvetheissue:
From`if auto_create_table or overwrite:`to`if auto_create_table and overwrite:`
What did you expect to see?
Expectation:
The function does not attempt to create a table (do not perform a "CREATE TABLE", with or without "IF NOT EXISTS").
The function performs a TRUNCATE of the table before loading the data with COPY INTO.
Can you set logging to DEBUG and collect the logs?
github-actionsbot
changed the title
The overwrite parameter does not behave as documented in write_pandas()
SNOW-1660544: The overwrite parameter does not behave as documented in write_pandas()
Sep 11, 2024
Python version
Python 3.11.0rc1 (main, Apr 21 2024, 22:33:16) [GCC 11.4.0]
Operating system and processor architecture
Linux-6.5.0-1025-azure-x86_64-with-glibc2.35
Installed packages
What did you do?
What did you expect to see?
Expectation:
The function does not attempt to create a table (do not perform a "CREATE TABLE", with or without "IF NOT EXISTS").
The function performs a TRUNCATE of the table before loading the data with COPY INTO.
Can you set logging to DEBUG and collect the logs?
The text was updated successfully, but these errors were encountered: