DuckDB connections should reflect correctly on UI

[sunank200]

The DuckDB connection configured in airflow_settings.yaml is created on the UI, but its custom File field comes up blank - even when set in the Host field as shown in ci-test-connections.yaml. I had to set it with an env var os.environ['AIRFLOW_CONN_DUCKDB_CONN'] = 'duckdb://%2Ftmp%2Fdb.duckdb'

Unless I’m configuring airflow_settings.yaml wrong, the 1st item should be addressed on the Hook’s UI field behavior.

[josh-fell]

Setting up airflow_settings.yaml in a local Astro project like this worked for me:

airflow:
  connections:
    - conn_id: duckdb
      conn_type: duckdb
      conn_host: duckdb://%2Ftmp%2Fdb.duckdb