Exchange rate data in the Data Lake is composed of 1 table view:
Project Space: prj-data-pricing-dev
See how this entity relates to the others in the pricing data model here.
View ID: prj-data-pricing-dev.DataOcean.V_DIM_exchange_rate
| fullname | mode | type | description |
|---|---|---|---|
| exchange_rate_key | STRING | ||
| source_system_id | STRING | ||
| effective_date | DATE | ||
| from_currency | STRING | ||
| to_currency | STRING | ||
| exchange_rate | FLOAT | ||
| ratio_for_from_currency | FLOAT | ||
| ratio_for_to_currency | FLOAT | ||
| exchange_rate_type | STRING | ||
| exchange_rate_type_usage | STRING | ||
| system_id | STRING | ||
| inserted_date | TIMESTAMP | ||
| updated_date | TIMESTAMP | ||
| delete_flag | BOOLEAN |
-