Hey Everyone! Just getting started with Meltano. I am looking at setting up Airflow and am trying to configure

AIRFLOW_CORE_SQL_ALCHEMY_CONN

. By default it utilizes a sqllite database, but is it recommended to utilize something like postgres? (similar to what is recommended for the meltano system database)? I tried using a postgres URI but I receive the following errors

ModuleNotFoundError: No module named 'psycopg2'

. I tried both

postgresql://

and also

postgresql+psycopg2

https://docs.meltano.com/guide/advanced-topics#installing-optional-components ie

pipx install meltano[postgres]

@visch that is for meltano, not airflow

@Conner Panarella what you probably need is to update the

pip_url

to include the missing dependency

@Edgar Ramírez (Arch.dev) Got it, that worked. 🤦‍♂️ Didn't realize the

pip_url

could be modified like that