meltano / jaffle-shop-template

Template for a DuckDB-based, Codespace-oriented sandbox project that is also dbt Cloud compatible, and includes code-first BI tooling via Evidence.
https://meltano.github.io/jaffle-shop-template/
10 stars 15 forks source link

Feat: add exchangerates data #12

Open aaronsteers opened 1 year ago

aaronsteers commented 1 year ago

No API key needed. And rate limits were not a problem going back to Jan 1 2020.

And entire EL run takes <20 second, including load time to target-duckdb:

meltano run tap-exchangeratehost target-duckdb

Or to force a full refresh:

meltano run tap-exchangeratehost target-duckdb --full-refresh

As of now, I don't have any transformations to make use of this data, but I thought I'd neverthess kick off this PR as a conversation starter for this or other sources.