meltano-playground/README.md

# Meltano Playground


- Install meltano
- start project
- add extractor and loader
- configure extractor and loader
- meltano run name-of-extractor name-of-loader
- meltano add utility dbt-postgres; meltano invoke dbt-postgres:initialize


psql -h localhost -p 5432 -U app -d app_db -c "SELECT 'customers' AS table, COUNT(*) FROM public.customers UNION ALL SELECT 'pizza_orders', COUNT(*) FROM public.pizza_orders;"


psql -h localhost -p 5444 -U dw -d dw_db -c "SELECT 'customers' AS table, COUNT(*) FROM tap_app.customers UNION ALL SELECT 'pizza_orders', COUNT(*) FROM tap_app.pizza_orders;"
first commit 2025-07-24 17:39:57 +02:00			`# Meltano Playground`

utilities 2025-07-25 16:51:18 +02:00

			`- Install meltano`
			`- start project`
			`- add extractor and loader`
			`- configure extractor and loader`
			`- meltano run name-of-extractor name-of-loader`
add dbt run 2025-07-27 09:27:54 +02:00			`- meltano add utility dbt-postgres; meltano invoke dbt-postgres:initialize`
utilities 2025-07-25 16:51:18 +02:00


			`psql -h localhost -p 5432 -U app -d app_db -c "SELECT 'customers' AS table, COUNT() FROM public.customers UNION ALL SELECT 'pizza_orders', COUNT() FROM public.pizza_orders;"`


			`psql -h localhost -p 5444 -U dw -d dw_db -c "SELECT 'customers' AS table, COUNT() FROM tap_app.customers UNION ALL SELECT 'pizza_orders', COUNT() FROM tap_app.pizza_orders;"`