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

            Unassigned Unassigned
            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