snowflake-sqlalchemy
snowflake-sqlalchemy copied to clipboard
SNOW-922868: Preserve the sequence order of foreign keys when dealing with composite keys.
Hi Team,
I am encountering issues while working with composite foreign keys. For every version, I am receiving fixed create_foreign_key and drop_constraint operations. Upon debugging, I discovered that we are not preserving the sequence order of foreign keys when comparing with metadata.
For more detail, I am pointing out the specific code snippet that requires modification. - https://github.com/snowflakedb/snowflake-sqlalchemy/blob/main/src/snowflake/sqlalchemy/snowdialect.py#L414-L434C18