Countries
Table name: countries
Contains standardized country reference data including currency, language, and regional configuration settings. Provides core country attributes used across the data platform for regional localization and compliance checks.
SQL: countries
Schema
| Column Name | Data Type | Description |
|---|---|---|
| Primary ID | ||
| id | INTEGER | Primary key |
| Other IDs | ||
| currency_id | INTEGER | Foreign key reference to the currency table |
| Timestamps | ||
| updated_at | TIMESTAMP_NTZ | Timestamp when the country record was last modified |
| created_at | TIMESTAMP_NTZ | Timestamp when the country record was initially created |
| Filters | ||
| is_sanctioned | BOOLEAN | Indicates whether the country is under international sanctions. True if sanctioned, false otherwise |
| Attributes | ||
| name | VARCHAR | Full country name in English |
| currency | VARCHAR | Three-letter ISO currency code (e.g. USD, EUR, GBP) used in this country |
| language | VARCHAR | Primary language code for the country following ISO standards |
| code_2 | VARCHAR | Two-letter ISO country code (e.g. US, GB, DE) |
| code_3 | VARCHAR | Three-letter ISO country code (e.g. USA, GBR, DEU) |
| phone_code | VARCHAR | International dialing code without plus symbol (e.g. 1, 44, 49) |
| decimal_separator | VARCHAR | Character used to separate decimal places in numbers (e.g. . or ,) |
| thousand_separator | VARCHAR | Character used to separate thousands in numbers (e.g. , or .) |
Data Inclustion Criteria
- is not deleted
Updated 20 days ago
Did this page help you?