Airflow3 from Docker-compose missing sqlite provider

[garthoid]

My airflow3 test environment from the docker-compose (https://airflow.apache.org/docs/apache-airflow/stable/howto/docker-compose/index.html) does not appear to have a sqlite provider. What did I miss and how can I (hopefully easily) add this to my environment?

[garthoid]

Any I will answer my own question. This may not be the best approach but I was able to get the provider into the providers list so I could create a connection object.

1. Using docker exec, connect to the running container with a bash shell as "default"
2. pip install apache-airflow-providers-sqlite
3. Exit shell
4. Restart containers (docker compose down/docker compose up)

Although this provides the provider in the dropdown list its a janky approach. Looking for something more stable.

[potiuk]

You need to build your own image / extend airflow's image. Our quick-start docker compose explains how and provides example. Just FYI - you do not need sqlite provider to use sqlite as Airflow metadata db - it's only needed if you want to itnterat with some sqlite databases via sql operators.

[garthoid]

t's only needed if you want to itnterat with some sqlite databases via sql operators.

This is exactly my use case. Otherwise the docker-compose provided has all I need.

Thank you