Drop and read index using SQLAlchemy

Question

I want to do a bulk insertion in SQL alchemy and would prefer to remove an index prior to making the insertion, reading it when the insertion is complete.

I see adding and removing indexes is supported by Alembic for migrations, but is this possible with SQLAlchemy? If so, how?

Answer 1

The best method is to just execute sql. In this casesession.execute("DROP INDEX ...")