Here is what our customer did:
data = pd.DataFrame([('1.0.0',)])
data.to_sql('version', schema='testschema', index=True, index_label='col1',
con=connection, if_exists='replace')
The problem is that the default value for index is True in pandas. It
proceeds to create the default Table object form
On Mon, Feb 11, 2019 at 4:33 PM mark.keller via sqlalchemy
wrote:
>
> Hi,
>
> I'm working on a bug that emerges when a user tries to use Pandas and
> SQLAlchemy with a Snowflake database and tries to push a data frame to the
> database.
> I'm trying to disallow users from submitting a "CREATE
Hi,
I'm working on a bug that emerges when a user tries to use Pandas and
SQLAlchemy with a Snowflake database and tries to push a data frame to the
database.
I'm trying to disallow users from submitting a "CREATE INDEX ..." SQL
commands to snowflake, which pandas tries to do by default, but