preview__dim_currency


Description

All available currencies

Columns

Column Type Size Nulls Auto Default Children Parents Comments
currency_id varchar 256 null
fct_revenue_invoice_based.currency_id Implied Constraint R
preview__fct_revenue_invoice_based.currency_id Implied Constraint R

Primary key of this table.
name varchar 256 √ null

Human readable name of the currency
code varchar 256 √ null

ISO 4217 currency code
numeric_code int8 19 √ null

ISO 4217 numeric code
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation