GeoLocation
Provides the display name for a given geo Id, or a set of geo Ids.
GeoLocation requires an Id in SELECT statements. For example:
SELECT * FROM geolocation where id = 'urn:li:geo:123456'To specify multiple geolocation Ids use the IN operator:
SELECT * FROM geolocation WHERE id IN (<List of geolocation ids>)
Columns
Name | Type | Description |
Id [KEY] | String | Unique identifier for the entity. Can be a single Id or a comma-separated list of Ids. |
Country | String | An uppercase two-letter country code as defined by ISO-3166. |
Language | String | A lowercase two-letter language code as defined by ISO-639. |
Value | String | The value of the display text. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
LocaleLanguage | String | The locale language the country data is requested in. A lowercase two-letter language code as defined by ISO-639.
The default value is en. |
LocaleCountry | String | The locale country the country data is requested in. An uppercase two-letter country code as defined by ISO-3166.
The default value is US. |