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

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

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

2019-02-11 Thread mark.keller via sqlalchemy
I just found that I could add a before_creation listener to the default Table object. However; I would like to still discuss possibly overwriting the methods in the default SchemaGenerator. On Monday, February 11, 2019 at 1:33:39 PM UTC-8, mark@snowflake.com wrote: > > Hi, > > I'm working

[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

[sqlalchemy] Adding new Snowflake feature to SQLAlchemy

2019-01-26 Thread mark.keller via sqlalchemy
Hi, I was working on adding support for our MERGE (upsert) command (https://docs.snowflake.net/manuals/sql-reference/sql/merge.html) to snowflake-sqlalchemy. First I tried to patch/replace the Table object to achieve an interface like ... meta = MetaData() meta.reflect(bind=session.bind,