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;"