Provider Overview:
IPinfo's industry-leading IP address data is now available directly in Snowflake and includes…
1. Enterprise-Grade Accuracy: Industry leading data accuracy with daily update options, underpinned by a global validation system that includes over 300 trace route networks.
2. Universal Access: Easily accessible via The Marketplace by anyone in the organization, reducing the engineering burden of traditional set up processes and simplifying procurement.
3. Highly Performant and Scalable: Ready to use UDF/UDTFs for data optimization meaning blazingly-fast queries only take a few seconds to run regardless of how many IPs are being queried.
IP Country + ASN Data Overview:
IPinfo's free IP Country + ASN data set combines country level geolocation and ASN information under one listing, with unrestricted access including daily refresh frequency and commercial licensing (licensed under CC BY-SA 4.0).
This free data set has been created to provide new users with a faster path to value realization from using enriched IP data without having to assign any budget!
▸ Country level IP geolocation: includes country and continent details, which identifies the location of IP addresses. This information is useful for tracking the origin of internet traffic, assigning geolocation-based attributes to internet traffic, monitoring and controlling website access by country, compliance with data protection regulations, digital rights management, fraud detection and prevention and more.
▸ ASN (Autonomous System Number): this data identifies internet service providers (ISPs), data centers, cloud providers, corporations, educational institutes, large institutional organizations, and other organizations that operate their own networks on the internet. You can use the ASN fields to identify which organization controls a range of IP addresses.
▸ Technical attributes:
◦ Full /32 subnet coverage, no data compromise or missing fields
◦ IP ranges are flattened and optimized for lookups
◦ The tabular structure of the data set simplifies data ingestion and integration
▸ Tables included:
◦ COUNTRY_ASN: The IP Country + ASN data set
▸ Check out the Data Dictionary for more information on tables and fields included in this listing.
Example data enrichment use cases:
IP address data has broad applicability across industry verticals for the majority of internet data use cases. The most significant and popular use cases currently align to cybersecurity, fraud prevention and content protection, with some examples below:
1. Network management: Adding geolocation & ASN context to network activity provides valuable insights for internet traffic control, monitoring, and management. Use this intelligence to create (and automatically update) network policies based on geolocation boundaries, limit access from specific territories, and identify common geolocation attributes of malicious actors (e.g. connection via a hosting provider, which could potentially be used to tunnel traffic, and mask the true IP address).
2. SecOps: Enhance threat intelligence, detection and incident response programs by enriching log data with geolocation and ASN context to enforce network controls, trigger alerts early and streamline investigations.
3. Customer 360 and Segmentation: Enrich intent data and sales intelligence through visitor identification and contextual IP intelligence. Classify internet traffic by geography and AS name.
Conditions:
Access to the data provided in this public listing is licensed for internal and commercial purposes.
How to get started?:
Get started immediately for FREE directly on The Marketplace.
We strongly advise you to leverage the IPinfo Snowflake Documentation: https://ipinfo.io/developers/integrations#snowflake to get up and running quickly and to support throughout using the data.
▸ Additional guidance:
◦ For query operation and IP log enrichment, we recommend using the provided UDTFs (IP_COUNTRY_DETAILS, IP_ASN_DETAILS and IP_DETAILS)
◦ For IP address management operations, we recommend using the provided UDFs (see technical docs)
◦ For further guidance check out The IPinfo Snowflake Community site: https://community.ipinfo.io/docs?tags=snowflake
For more granularity…
◦ If you require more in-depth IP Geolocation data, e.g. city, region, zip/postal code and geographic coordinates, check out https://app.snowflake.com/marketplace/listing/GZSTZ3VDMFI/
◦ If you require more in-depth ASN data, e.g. ‘AS country’ & ‘AS organization type’, check out https://app.snowflake.com/marketplace/listing/GZSTZ3VDMFM/
Contact us:
Do you need more data types, want to discuss customization, or have any other questions? Reach out to our data experts at snowflake@ipinfo.io