*** work in progress, not working yet ***
This is a demo project to show how to use Meltano to transform data with DBT Python models and load on Postgres database by using dbt-postgres-python dbt adapter.
-
Copy env.example to .env and fill in the required values.
-
Run postgres database using docker-compose:
docker-compose up -d
- Install Meltano project dependencies:
pipx install meltano
pip install -r requirements.txt
meltano install
- Run the ETL pipelie:
meltano run food-data