ETL: CityNameFromIP

Look up and return the city name associated with an IPv4 address in dot-decimal notation. Use for IP-based geolocation in ETL data pipelines.

Description

Extracts the city name from a given IPv4 string (dot-decimal notation).

Syntax

CityNameFromIP(ipaddress)

Examples

CityNameFromIP('128.193.8.81') returns ‘Corvallis’.

Notes

The function uses GeoLite2 data created by MaxMind, available from http://www.maxmind.com

Return value datatype

String

Impact of null value

If input is null, returns null.