data-dwh-dbt-project/models/reporting/general/daily_currency_exchange_rates.sql

15 lines
426 B
MySQL
Raw Permalink Normal View History

2024-06-19 11:59:45 +02:00
with
int_daily_currency_exchange_rates as (
select * from {{ ref("int_daily_currency_exchange_rates") }}
)
2024-06-19 11:52:28 +02:00
select
id_exchange_rate as id_exchange_rate,
from_currency as from_currency,
to_currency as to_currency,
rate as rate,
rate_date_utc as rate_date_utc,
source as source,
rate_version as rate_version,
updated_at_utc as updated_at_utc
2024-06-19 11:59:45 +02:00
from int_daily_currency_exchange_rates