dim_rate_localized


Description

The localized version of a rate, defining translated information of a rate per locale. One rate can have multiple localized versions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rate_localized_id varchar 256 null

The primary key of this table.
rate_id int8 19 √ null
dim_rate.rate_id erp_v2_dim_rate_localized_rate_id__erp_v2_dim_rate_rate_id_fkey_3be38d4e221e R

The foreign key to the rate table.
locale varchar 256 √ null

The locale representing the language and region for which the rate is translated, formatted as a combination of ISO-639 language code and ISO-3166 country code (e.g., de_DE).
public_name varchar 65535 √ null

The public name given to this rate for this locale by a user.
description varchar 65535 √ null

The description given to this rate for this locale by a user.
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