snowflakedb / snowflake-sqlalchemy

Snowflake SQLAlchemy
https://pypi.python.org/pypi/snowflake-sqlalchemy/
Apache License 2.0
234 stars 152 forks source link

SNOW-1023317: Add support for RELY #463

Open manalC1 opened 9 months ago

manalC1 commented 9 months ago

Description :

Currently we can't define on Columns the option : snowflake_rely=True unless we use @compiles decorator on CreateTable or we use event.listen after tables creation

What is the desired behavior?

The ability to set rely on constraints when defining a table like this : Table('table_name', metadata, Column('col_name', col_type, primary_key=True, snowflake_rely=True), Column('col_name', col_type, ForeignKey("t.col"), snowflake_rely=True) )

How would this improve snowflake-connector-python?

Add the functionality