ETL: ContinentCodeFromIP

Look up and return the two-letter continent code for an IPv4 address in dot-decimal notation. Use for geo-analysis in ETL data pipelines.

Description

Extracts the continent code from a given IPv4 string (dot-decimal notation).

Syntax

ContinentCodeFromIP(ip_address)

Examples

ContinentCodeFromIP('69.59.196.211') returns ‘NA’

Notes

ContinentCodeFromIP uses Maxmind for extracting the continent code.

Return value datatype

String

Impact of null value

If input is null, returns null.