✨ Countries (NEW)

✨ NEW TABLE - November 2025

🛠️ Partner API Alignment Migration

✅ This table is new as of November 2025 and will not be impacted

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

Alignment

Aligns with Partner API get/countries endpoint