GEO_IP
Use an IP Address to lookup geo information
GEO_IP(attributes1[, attributes2, ..., attributesN], IP Address)
Name | Type | Description | Default Value |
|---|---|---|---|
attributes# | geoipattribute | The attribute to extract for the given IP address | |
IP Address | string | The IP address to use for geo ip information lookup | |
attributes | IP Address | Output |
|---|---|---|
'Locale Code' | '2.87.124.4' | en |
'Continent Code' | '2.87.124.4' | EU |
'Continent Name' | '2.87.124.4' | Europe |
'Country Iso Code' | '2.87.124.4' | GR |
'Country Name' | '2.87.124.4' | Greece |
'Subdivision 1 Iso Code' | '2.87.124.4' | L |
'Subdivision 1 Name' | '2.87.124.4' | South Aegean |
'City Name' | '2.87.124.4' | Rhodes |
'Metro Code' | '2.87.124.4' | `` |
'Time Zone' | '2.87.124.4' | Europe/Athens |
CREATE JOB function_operator_example
ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
SELECT attributes, IP Address,
GEO_IP('Locale Code', IP Address) AS Output
FROM default_glue_catalog.upsolver_samples.orders_raw_data
LET attributes = 'Locale Code',
IP Address = '2.87.124.4'
WHERE time_filter()
LIMIT 1;
attributes | IP Address | Output |
|---|---|---|
'Locale Code' | '2.87.124.4' | en |
Last modified 28d ago