Queries for localized data

The locale keyword is used to select localized string values stored in data objects in Data Lake. For Compass queries, the localized data is stored in Compass data storage when a query is run. Therefore, it is critical that the Locale Selections are defined before you query the data object.

If the Data Catalog locale selections are updated after data is stored in Compass data storage, use the administration stored procedure to clear the table and data. The next time a query is run, Compass data storage uses the current locale selections and includes the localized values stored in Data Lake.

Updating locale selections in the Data Catalog before they can be used in Compass can take up to four hours.