Table of Contents | ||||||
---|---|---|---|---|---|---|
|
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 |