#🔒 Alembic revision autogenerate failing on temp tables

4 messages · Page 1 of 1 (latest)

urban widget
#

I am trying to autogenerate a revision with Alembic, but it is failing on temp tables that seem to be created by alembic itself. I am using an Azure SQL Edge database for local development. When the database is initialized the tempdb has no tables, SELECT * FROM [INFORMATION_SCHEMA].[TABLES]; gives no resulting tables. When I run alembic revision --autogenerate it fails with the following error: sqlalchemy.exc.NoSuchTableError: #A3D0F02D.

Alembic appears to be creating these tables, as they do not initially exist. In the echo-ed engine SQL operations I do not see any temp table creations occuring, yet they are there after. I am trying to just add a single Hero example table to the database.

|TABLE_CATALOG|TABLE_SCHEMA|TABLE_NAME|TABLE_TYPE|
|---|---|---|---|
|tempdb|dbo|#A3D0F02D|BASE TABLE|
|tempdb|dbo|#AB71CB6A|BASE TABLE|
blissful trailBOT
#

@urban widget

Python help channel opened

Remember to:

  • Ask your Python question, not if you can ask or if there's an expert who can help.
  • Show a code sample as text (rather than a screenshot) and the error message, if you've got one.
  • Explain what you expect to happen and what actually happens.

:warning: Do not pip install anything that isn't related to your question, especially if asked to over DMs.

Closes after a period of inactivity, or when you send !close.
blissful trailBOT
#

@urban widget

Python help channel closed

This help channel has been closed and it's no longer possible to send messages here. If your question wasn't answered, feel free to create a new post in #1035199133436354600. To maximize your chances of getting a response, check out this guide on asking good questions.