| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
| Note |
|---|
Deprecated operation This operation is deprecated. Use Geolocated City with MaxMind GeoIP2 (mm2city) instead. |
Description
Geolocates an IPv4 address and returns the corresponding city name.
| Note |
|---|
This operation returns data for public IP addresses. If an IP is private, it will return null. |
| Note |
|---|
Use the Geolocated City with MaxMind GeoIP2 (mm2city) operation if you want to get the cities corresponding to your IPv6 addresses (ip6 data type). |
...
Use the operator select... as... and add the operation syntax to create the new column. The syntax is as follows:
mmcity(ip)
Example
Copy the following LINQ script and try the above example on the demo.ecommerce.data table.
| Code Block |
|---|
from demo.ecommerce.data select mmcity(clientIpAddress) as city |