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.
*On Snowflake marketplace
- Price
30 days free trial
- Category
Cybersecurity
- Access
On the Snowflake Marketplace
- Requirements
No requirement
![Joren McReynolds](png/joren-mcreynolds.png)
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.
Free IPinfo dataset on Snowflake Marketplace
Unrestricted, Snowflake-optimized access to a subset of our full proprietary data
View on SnowflakePaid 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_ipFirst IP in the range
8.8.8.8
- end_ipLast IP in the range
8.8.8.8
- countryCountry code (ISO2)
US
- cityCity of the location
Mountain View
- regionRegion of the location
California
- latLatitudinal code
37.405992
- postalPostal code
94035
- lngLongitudinal code
-122.078515
- timezoneLocal time zone
America / Los_Angeles
IP to Privacy Detection
Discover VPN, proxy, tor, relay usage, or hosting providers (such as bots or scrapers) that are hiding IP addresses
- start_ipFirst IP in the range
8.8.8.8
- end_ipLast IP in the range
8.8.8.8
- torTRUE or FALSE flag
false
- hostingTRUE or FALSE flag
false
- is_privacyTRUE or FALSE flag
false
- proxyTRUE or FALSE flag
false
- vpnTRUE or FALSE flag
false
- relayTRUE or FALSE flag
false
- servicePrivacy service name
""
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_ipFirst IP in the range
8.8.8.8
- end_ipLast IP in the range
8.8.8.8
- nameCarrier company name
T-Mobile
- countryCountry code (ISO2)
US
- mccMobile Country Code
310
- mncMobile Network Code
120
- is_carrierTRUE or FALSE flag
false
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_ipFirst IP in the range
8.8.8.8
- end_ipLast IP in the range
8.8.8.8
- nameName of organization
Google LLC
- domainDomain name of the ASN
google.com
- typeBusiness, ISP, hosting or education
business
- asnAutonomous System Number
AS15169
- as_nameName of organization
Google
- as_domainDomain name of the ASN
google.com
- as_typeBusiness, ISP, hosting or education
business
- countryCountry code (ISO2)
US
IP Whois Summary
IP Whois Summary dataset provides contextual, consistent and structured insights from RIR.
- rangeIP address range
8.8.8.0/24
- idUnique identifier of the IP address range
LVLT-GOGL-8-8-8
- nameName of organization
Google LLC
- countryCountry code (ISO2)
US
- statusCurrent status
REALLOCATION
- techTechnical contact
ZG39-ARIN
- maintainerOrganization responsible for maintaining the range
""
- adminAdministrative contact
ZG39-ARIN
- sourceRIR that assigned the IP address range
arin
- whois_domainDomain name of the organization
GOOGLE LLC
- updatedDate of last update
2019-10-31
- orgName of the organization
Google LLC
- rdns_domainDomain name associated with the reverse DNS record
google.com
- domainDomain name
business
- geolocCountry code (ISO2)
US
- org_addressASN address
AS15169
- asnAutonomous System Number
Google
- as_nameName of organization
Google
- as_domainDomain name of the ASN
google.com
- as_typeBusiness, ISP, hosting or education
business
IP to Hosted Domains
IPinfo's Hosted Domains (or Reverse IP) database returns information on domains hosted on IP address.
- ipIP address
8.8.8.8
- totalNumber of domains
13704
- domainsList of domains
qiuxueshe.com,nbalxhf.com,61wwxs.com...
IP to rDNS (Reverse DNS Resolution)
Get a domain name associated with an IP address from DNS PTR records.
- start_ip_intStarting IP address in integer format
8.8.8.8
- end_ip_intEnding IP address in integer format
8.8.8.8
- join_keyKey used to join
8.8.8.8
- start_ipStarting IP address in string format
8.8.8.8
- end_ipEnding IP address in string format
8.8.8.8
- sizeNumber of IP addresses in the range
13704
- domainDomain name
google.com
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.
Test our data with
these queries
![Team logo](png/glyph-white.caa65162.png)
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