Re: [sqlalchemy] Disable create index SQL command in SnowflakeDialect

2019-02-11 Thread mark.keller via sqlalchemy
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

Re: [sqlalchemy] Disable create index SQL command in SnowflakeDialect

2019-02-11 Thread Mike Bayer
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

[sqlalchemy] Disable create index SQL command in SnowflakeDialect

2019-02-11 Thread mark.keller via sqlalchemy
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