Look up geolocation for IP address
Resolve an IP address to its various geolocation attributes such as country, longitude, and latitude.
Example
ip_address |
| 54.193.34.3 |
| 213.34.56.96 |
→
IP_ADDRESS | country | city | longitude | latitude |
| 54.193.34.3 | United States | San Jose | -121.8914 | 37.3388 |
| 213.34.56.96 | Netherlands | Tilburg | 5.093 | 51.5672 |
Configuration
Column
Select a column from the table that contains ip addresses.
Fields
Select geolocation fields that should be added as columns. You can choose from the following fields: Country, City, Longitude, Latitude, Region, Postal Code, Metro Code, Country Code, Region Code
Look Up Method
Select the look up method. Only IP Address is available.
Key Considerations
Geolocation columns are populated with null if the value is not recognized as an IP address.