aaronsteers
03/31/2023, 10:26 PMmeltano init my-jaffle-demo && cd my-jaffle-demo
meltano add extractor tap-jaffle-shop
meltano add loader target-jsonl
meltano run tap-jaffle-shop target-jsonl
To see a finished end-to-end project, including dbt Transforms and Evidence BI reports, check out the new Meltano Jaffle Shop Template. This is is an extended MDS-in-a-Box approach with DuckDB as the warehouse and GitHub Pages used to publish the BI reports.
Thanks to the dbtLabs team for creating the Python-based jafgen data generator and the base dbt project template.
Enjoy your jaffles! 🏭 : 🥪 🥪 🥪 🥪 🥪 🥪mehdi_sidi_boumedine
04/03/2023, 3:33 PMmeltano init my-jaffle-demo && cd my-jaffle-demo
meltano add extractor tap-jaffle-shop
meltano add loader target-jsonl
meltano run tap-jaffle-shop target-jsonlaaronsteers
04/03/2023, 10:04 PMoutput at the base of the created project folder.aaronsteers
04/03/2023, 10:14 PMoutput folder just like target-jsonl.
Here's the DuckDB-centric speedrun: 🏎️ 🦆
meltano init my-jaffle-demo2 && cd my-jaffle-demo2
meltano add extractor tap-jaffle-shop
meltano add loader target-duckdb
meltano run tap-jaffle-shop target-duckdb
And you should find the full dataset loaded into a new DuckDB database file at my-jaffle-demo2/output/warehouse.duckdb data partyedgar_ramirez_mondragon
04/04/2023, 1:56 AMtobias_brandt
04/04/2023, 9:24 AMmeltano/meltano:latest Docker image I get the following error:
root@c08fa1186d73:/project/jaffle# meltano add extractor tap-jaffle-shop
Added extractor 'tap-jaffle-shop' to your Meltano project
Variant: meltanolabs (default)
Repository: <https://github.com/MeltanoLabs/tap-jaffle-shop>
Documentation: <https://hub.meltano.com/extractors/tap-jaffle-shop--meltanolabs>
Installing extractor 'tap-jaffle-shop'...
Extractor 'tap-jaffle-shop' could not be installed: failed to install plugin 'tap-jaffle-shop'.
Running command git clone --filter=blob:none --quiet <https://github.com/MeltanoLabs/tap-jaffle-shop.git> /tmp/pip-req-build-sf9pv1hm
ERROR: Ignored the following versions that require a different python version: 0.2.1 Requires-Python >=3.10; 0.3.1 Requires-Python >=3.10
ERROR: Could not find a version that satisfies the requirement jafgen<0.4.0,>=0.3.1 (from meltanolabs-tap-jaffle-shop) (from versions: none)
ERROR: No matching distribution found for jafgen<0.4.0,>=0.3.1
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.
Failed to install plugin(s)
root@c08fa1186d73:/project/jaffle#
Looks like it requires Python3.10 while that image only has Python3.9.tobias_brandt
04/04/2023, 9:30 AMmeltano/meltano:latest-python3.10 image it worked fine! 🎉tobias_brandt
04/04/2023, 10:46 AMalias meltano='docker run --rm -it --user $(id -u):$(id -g) -v $(pwd):/project meltano/meltano:latest-python3.10'aaronsteers
04/04/2023, 4:11 PMaaronsteers
04/04/2023, 4:14 PMaaronsteers
04/04/2023, 4:14 PM