Want all of the data behind our APIs? Our downloadable IP address databases deliver insights into millions of IPs

Learn more

IPinfo for Snowflake

Access our industry-leading IP address datasets. They're optimized for the Snowflake platform and suitable for business intelligence, analytics, big data, and cybersecurity use cases.

Start free trialBrowse listings

*On Snowflake marketplace

Joren McReynolds

As a cloud-native SIEM that provides highly-scalable, real-time threat detection, Panther needs effective enrichment to make sure customers get the context they need fast. As a fellow Snowflake partner, IPinfo was an ideal choice for seamless alert enrichment - quickly adding the geolocation and ASN context our customers need to tune detections and accelerate triage.

Joren McReynolds — SVP of Engineering, Product & Design, Panther

Free IPinfo dataset on Snowflake Marketplace

Unrestricted, Snowflake-optimized access to a subset of our full proprietary data

View on Snowflake
Stacked Layers Graphic

Paid IPinfo listings on Snowflake Marketplace

Our Snowflake-optimized data and user functions are available in all Snowflake regions via the marketplace.

  • IP to Geolocation

    Get geolocation details for a given IP address: country, city, state or region, lat/long, postal code, and timezone.

    • start_ip
    • end_ip
    • country
    • city
    • region
    • lat
    • postal
    • lng
    • timezone
    Contact sales for sample

  • IP to Privacy Detection

    Discover VPN, proxy, tor, relay usage, or hosting providers (such as bots or scrapers) that are hiding IP addresses

    • start_ip
    • end_ip
    • tor
    • hosting
    • is_privacy
    • proxy
    • vpn
    • relay
    • service
    Contact sales for sample

  • IP to Mobile Carrier

    Discover if an IP address belongs to a Mobile Carrier: carrier name, Mobile Country Code (MCC), and Mobile Network Code (MNC).

    • start_ip
    • end_ip
    • name
    • country
    • mcc
    • mnc
    • is_carrier
    Contact sales for sample

  • IP to Company

    Gather data on the companies behind IP traffic: company name, domain name, and whether the company an ISP, business or hosting service.

    • start_ip
    • end_ip
    • name
    • domain
    • type
    • asn
    • as_name
    • as_domain
    • as_type
    • country
    Contact sales for sample

  • IP Whois Summary

    IP Whois Summary dataset provides contextual, consistent and structured insights from RIR.

    • range
    • id
    • name
    • country
    • status
    • tech
    • maintainer
    • admin
    • source
    • whois_domain
    • updated
    • org
    • rdns_domain
    • domain
    • geoloc
    • org_address
    • asn
    • as_name
    • as_domain
    • as_type
    Contact sales for sample

  • IP to Hosted Domains

    IPinfo's Hosted Domains (or Reverse IP) database returns information on domains hosted on IP address.

    • ip
    • total
    • domains
    Contact sales for sample

  • IP to rDNS (Reverse DNS Resolution)

    Get a domain name associated with an IP address from DNS PTR records.

    • start_ip_int
    • end_ip_int
    • join_key
    • start_ip
    • end_ip
    • size
    • domain
    Contact sales for sample

Getting started

01

To get started you can visit Snowflake marketplace and add datasets directly to your account. Once you have access to our database, you will be able to make queries.

02

If you still have questions or would like to try our free sample data, you can contact our data experts, and we’ll be happy to assist and access the full datasets.

Contact sales

Test our data with
these queries

# Sample query
SELECT * FROM ip_log s JOIN IPINFO.location l ON IPINFO.TO_JOIN_KEY(s.ip) = l.join_key WHERE IPINFO.TO_INT(s.context_ip) BETWEEN l.start_ip_int AND l.end_ip_int
Team logo

Why IPinfo?

Not only does IPinfo offer accurate and efficient data, but our datasets are also optimized for Snowflake. Our databases are updated daily, giving users the most reliable IP address data available.

About us

Organizations around the world who trust IPinfo's data

Get started with IPinfo

Register free accountEnterprise