The difference between IPinfo's data in Snowflake and the IPinfo API

Snowflake is a data warehouse platform that acts as a central repository of an organization’s data. Therefore, if you are working with data, it will be fairly easy to bring data from different places into one centralized location and process it there.

Snowflake vs IPinfo API

IPinfo’s data delivered through Snowflake Marketplace means the data already lives there and is available in a database format. With our Snowflake IP database, you can access full data manipulation abilities, including IP lookups, reverse IP lookups, large-scale enrichment, unlimited queries, ranges extractions via IP metadata etc.

This differs from our IPinfo API service, which, based on your data access, supports IP lookups, ASN lookups, company range lookups, etc. However, it only provides limited manipulation ability for our IPinfo data.

If data manipulation is our priority, consider using our data in Snowflake. If you only want metadata information from IP addresses, ASNs, companies, etc., use our API service.

Snowflake SDK vs IPinfo API

One interesting point is that IPinfo’s data inside the Snowflake data warehouse is extremely easy to work with using its SDKs (also known as drivers or connectors). While traditional cloud platform SDKs require utility-based authentication, Snowflake uses credential-based authentication, making it extremely flexible and easy to use on various devices and operations.

With IPinfo Snowflake UDF, you can easily use the IP metadata from Snowflake in the same manner as you would use an API service.

SELECT *
FROM logs l
JOIN TABLE (ipinfo.public.ip_location(l.ip));

Because you can write standard SQL statements, you have more data wrangling and transformation capabilities than our IPinfo API service.

With the API service, you can easily get IP metadata information. The API service is easily accessible and usable. The response times of the API are extremely fast, and we also support bulk enrichment via API.

curl ipinfo.io/8.8.8.8?token=$token
{
  "ip": "8.8.8.8",
  "hostname": "dns.google",
  "anycast": true,
  "city": "Mountain View",
  "region": "California",
  "country": "US",
  "loc": "37.4056,-122.0775",
  "postal": "94043",
  "timezone": "America/Los_Angeles",
  "asn": {
    "asn": "AS15169",
    "name": "Google LLC",
    "domain": "google.com",
    "route": "8.8.8.0/24",
    "type": "hosting"
  },
  "company": {
    "name": "Google LLC",
    "domain": "google.com",
    "type": "hosting"
  },
  "privacy": {
    "vpn": false,
    "proxy": false,
    "tor": false,
    "relay": false,
    "hosting": true,
    "service": ""
  },
  "abuse": {
    "address": "US, CA, Mountain View, 1600 Amphitheatre Parkway, 94043",
    "country": "US",
    "email": "network-abuse@google.com",
    "name": "Abuse",
    "network": "8.8.8.0/24",
    "phone": "+1-650-253-0000"
  },
  "domains": {
    "ip": "8.8.8.8",
    "total": 9820,
    "domains": [
      "kuweimi.com",
      "musicool.cn",
      "nmgk2.com",
      "allnet.cn",
      "aonode.com"
    ]
  }
}

To learn more about our data solution, check out our documentation:

IPinfo provides data support in all possible ways that best match developers’ and companies’ expectations and processes. We recommend users explore our documentation and try out our database to understand which solutions best suit them.