dbt and the ECB f/x Rates – Part 3
- dbt and the ECB f/x Rates – Part 1
- dbt and the ECB f/x Rates – Part 2
- dbt and the ECB f/x Rates – Part 3
In this final article of this series I will add another data mart. In the models/marts subfolder we add fx_current_rates.sql with the following SQL code:
{{ config(materialized='view') }} SELECT currency, valid_from, rate_vs_eur FROM {{ REF('fx_rates_with_validity') }} WHERE is_current = TRUE |
This will be a new view on top of the „fx_rates_with_validity“ mart. As this view ‚materializes‘ in the Postgres DB, we can use HeidiSQL to retrieve data from it:
