Connection Type not visible in Airflow connections

16 Views Asked by At

I have installed Airflow in Local compluter using wsl2 where airflow is running on localhost:8080

i want to setup connection (name : postgres_localhost) to postgresql which is again installed in local but connection type Postgres is not visible when I am trying to setup connection in airflow

I have installed requried library (apache-airflow-providers-postgres)as well and restart the airflow

Can someone please suggest how can i setup connection to postgressql

from airflow.providers.postgres.operators.postgres import PostgresOperator

postgres_task = PostgresOperator(
        task_id='postgres_task',
        postgres_conn_id='postgres_localhost',
        sql='SELECT * FROM localuser'

)

I tried to used connection type Sqlite but it fails with error "sqlite3.OperationalError: unable to open database file"

0

There are 0 best solutions below