API token

google.com

host google.com

google.com has address 142.251.41.46

Snowflake: IPinfo Free IP Geolocation Sample - Usage Example

SELECT *
FROM demo.location
WHERE TO_INT('142.251.41.46') BETWEEN start_ip_int AND end_ip_int;

Query produced no results

We use an API token for IPinfo.io.

token= #my token
curl "ipinfo.io/142.251.41.46?token=${token}"

{
  "ip": "142.251.41.46",
  "hostname": "yyz12s08-in-f14.1e100.net",
  "city": "Toronto",
  "region": "Ontario",
  "country": "CA",
  "loc": "43.7001,-79.4163",
  "org": "AS15169 Google LLC",
  "postal": "M5A",
  "timezone": "America/Toronto"
}

I did this in Toronto. Speculation: in any major city, google.com resolves to an IP address that will geolocate to that city.

Peking University

host pku.edu.cn

pku.edu.cn has address 162.105.131.160

token= #my token
curl "ipinfo.io/162.105.131.160?token=${token}"

{
  "ip": "162.105.131.160",
  "city": "Beijing",
  "region": "Beijing",
  "country": "CN",
  "loc": "39.9075,116.3972",
  "org": "AS24349 CERNET2 IX at Peking University",
  "timezone": "Asia/Shanghai"
}

TANet

host noc.tanet.edu.tw

noc.tanet.edu.tw has address 192.83.166.30

{
  "ip": "192.83.166.30",
  "city": "Taipei",
  "region": "Taiwan",
  "country": "TW",
  "loc": "25.0478,121.5319",
  "org": "AS1659 Taiwan Academic Network (TANet) Information Center",
  "timezone": "Asia/Taipei",
  "readme": "https://ipinfo.io/missingauth"
}

Snowflake

IPinfo Free IP Geolocation Sample

Speedtest data is used today by commercial fixed and mobile network operators around the world to inform network buildout, improve global Internet quality, and increase Internet accessibility. Government regulators such as the United States Federal Communications Commission and the Malaysian Communications and Multimedia Commission use Speedtest data to hold telecommunications entities accountable and direct funds for rural and urban connectivity development. Ookla licenses data to NGOs and educational institutions to fulfill its mission: to help make the internet better, faster and more accessible for everyone. Ookla hopes to further this mission by distributing the data to make it easier for individuals and organizations to use it for the purposes of bridging the social and economic gaps between those with and without modern Internet access.

Our IP geolocation data provides a response that includes every IP’s latitude and longitude coordinates, region, country, postal/ZIP code, and city. Using our IP address geolocation data, customers can resolve their web traffic to meaningful locations as specific as a street address. IPinfo builds and maintains its own proprietary IP geolocation database, which can be used to generate various forms of geographic information for your IP traffic.

IPinfo Snowflake Documentation: https://ipinfo.io/developers/integrations#snowflake

Included Cities and Regions:

This demo database, designed for Snowflake exploration and learning purposes, provides the complete IP address information for the following cities:

Denver, Colorado, US

Kenosha, Wisconsin, US

Sheboygan, Wisconsin, US

Gdańsk, Pomerania, PL

Warsaw, Mazovia, PL

Puducherry, Puducherry, IN

Madrid, Madrid, ES

Funafuti, Funafuti, TV

Nairobi, Nairobi, KE

Shanghai, Shanghai, CN

Shanghai Shipping Exchange

en.sse.net.cn

host en.sse.net.cn

en.sse.net.cn has address 117.184.142.41

Snowflake: IPinfo Free IP Geolocation Sample - Usage Example

IPinfo Free IP Geolocation Sample - Usage Example

SELECT CITY, COUNTRY, LAT, LNG
FROM IPINFO_FREE_IP_GEOLOCATION_SAMPLE.demo.location
WHERE IPINFO_FREE_IP_GEOLOCATION_SAMPLE.public.TO_INT('117.184.142.41') BETWEEN start_ip_int AND end_ip_int;

CITY,COUNTRY,LAT,LNG
Shanghai,CN,31.22222,121.45806