Uploaded image for project: 'Apache Airflow'
  1. Apache Airflow
  2. AIRFLOW-5933

Unable to define schema for alembic version table

    XMLWordPrintableJSON

    Details

      Description

      Airflow allows defining the database schema used by SQL alchemy via the sql_alchemy_schema setting in the core section of the config. Alembic does not use this schema for its version table, and will always use the version table in the default schema.

      To be able to host multiple airflow instances in 1 database (split across schemas), one should be able to specify the schema where the alembic version table is placed in as well.

      The fix for this is described in this stack overflow article: https://stackoverflow.com/questions/42316280/how-to-specific-table-schema-for-alembic-version-when-using-flask-migrate

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              axelgoblet Axel Goblet
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 3h
                3h
                Remaining:
                Remaining Estimate - 3h
                3h
                Logged:
                Time Spent - Not Specified
                Not Specified