AWS Airflow v2.0.2 doesn't show Postgres connection type
I just started migrating my Airflow v2.0.2 codebase to MWAA (AWS Airflow service). I added the following to the requirements.txt (and uploaded it to the S3 bucket intended for sync):
apache-airflow-providers-postgres==2.0.0
But Postgres connection type doesn't show up in the new connection UI:
What's going on here and how can I resolve this issue?
Solution
This is a known problem with MWAA (currently). It does not install Postgres provider in webserver currently. From what I know, this might be solved in the future, but for now I believe the only solution is to define connection manually via secret manager https://docs.aws.amazon.com/mwaa/latest/userguide/connections-secrets-manager.html
- How to return JSON objects without explicit aliasing in postgresql
- Postgresql + psycopg: Bulk Insert large data with POSTGRESQL function call
- Better way to insert a very large data into PostgreSQL tables
- Cannot drop PostgreSQL role. Error: `cannot be dropped because some objects depend on it`
- pgadmin4 : postgresql application server could not be contacted
- How can I specify the migrations directory for typeorm CLI?
- SQL full outer join, default value to column in other table
- PostgreSQL database not connecting to spring-boot application
- Setting auto increment id in Postgres with Navicat
- Dropping all views in postgreSql
- Where does PostgreSQL store configuration/conf files?
- Query produces "function unnest(unknown) is not unique error", but is executed fine by the application
- SQL statement evaluation order
- Execute multiple queries as one dblink transaction
- Spring Data R2DBC PostgreSQL not saving new record with UUID @Id
- PostgreSQL Stack Builder Installation Certificate verification problem on Windows
- How do you connect to postgres running in a Docker container on OSx?
- Order by the oldest relation Postgres
- How to create a role in postgress db which supports the CRUD operations but doesn't allow to drop the database and tables with that role
- Error calling procedure in posgres "No procedure matches the given name and argument types. You might need to add explicit type casts."
- How To Import a Big .csv(~2GB) Into a PostgreSQL Table
- Rails trying to connect to postgresql on port 5432, but it's configured for 5433
- Power BI, Postgres, and materialized views
- How do you name the PostgreSQL indexes when using Haystack's PgvectorDocumentStore?
- Postgresql showing only one decimal, Grafana showing 2
- Django Postgresql ORM optimisation
- "could not identify an equality operator for type json" when using distinct
- Syntax error at end of input in PostgreSQL
- How to increase the connection limit for the Google Cloud SQL Postgres database?
- postgresql timestamptz conversion to localtime issue