maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelstaging

stg_postgres__fx_rates

staging view

FX rates, cleaned.

Definition

Spot / average / closing rates by date used to translate transaction amounts to functional USD.

8 of 8
Column
Description
Tests · PII
fx_rate_id
Primary key — UInt64.
2 tests
from_currency
Source currency (ISO-4217, uppercased).
to_currency
Target currency (uppercased, default USD).
rate_date
Date the rate applies to. Date.
rate_type
Rate basis — spot / average / closing.
1 test
rate
Conversion rate. Decimal(18,8).
source_created_at
Row insert timestamp from the source DB. DateTime64(6).
airbyte_extracted_at
When the loader extracted this row from postgres-source.