SNOW-2313675: Alembic trying to create same migrations when using multi schema migrations

[gouthamravella]

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

   python3.12

2. What operating system and processor architecture are you using?

   macOS-15.5-x86_64-i386-64bit

3. What are the component versions in the environment (pip freeze)?

   snowflake-connector-python==3.17.2
   snowflake-sqlalchemy==1.7.6
   SQLAlchemy==2.0.43

4. What did you do?

   Trying to add alembic for version support. We have two schemas per database and using one schema to track the migrations and few tables having foreign key mappings between these schemas. Upon creating first migration, it created tables fine. When I add new columns to the tables, it is again creating tables in the new migration file but not detecting the changes columns only.

5. What did you expect to see?

   When creating a new migration, it should show only the changed columns

[sfc-gh-dszmolka]

(we're in maintenance mode, see README in the repo, unable to give any kind of timeline for when the issue actually will be addressed by the team. if it's critical to you, please follow the steps outlined in the README and raise a support case)

[sfc-gh-dszmolka]

The library is now out of maintenance mode 🎉, so reopening this issue. so it could be addressed per available resources.