On Snowflake, all of our listings come with their own unique UDTF (User Defined Table Functions) that is designed to enrich your IP database in the most efficient way possible. You should exclusively use these UDTFs if you are doing bulk IP data enrichment using our database.
The IP RWHOIS database is included in our IPinfo WHOIS Summary dataset (RIR) listing along with the IP RIR WHOIS database.
Please refer to our [Snowflake Listing Technical Guide] Integrations and Data Platforms - IPinfo.io) to learn more.
Let’s say your table containing the IP addresses is called
LOGS, and the column containing the IP address is called
IP. Based on this, use the provided
IP_RWHOIS UDTF from the
public schema of your IPinfo shared database.
SELECT * FROM logs l LEFT JOIN TABLE(ipinfo.public.IP_RWHOIS(l.ip))
Please note that the
ipinfo.public.IP_RWHOIScan be different for you. It depends on the name you gave to our listing when you purchased it.
The UDTF format is:
SELECT <column_containing_ip_addresses> FROM <input_table> <table.alias> JOIN TABLE(<data_share_name>.public.<UDTF_name>(<table_alias.column_name>))
The UDTF will return the IP RWHOIS related information for IPs which includes:
- IP address range
- WHOIS ID
- Organization name
- Country of the organization
- Email of the organization
- Abuse contact
- The official domain of the organization
- Street address of the organization
- Postal code
- Updated date
- Imported date
For invalid IP addresses or IP addresses that aren’t included in our database, the outputted table will not include their information
If you want to learn about the technical aspect of how we came up with these UDTFs and the process behind their efficiency, read this article: How to get IP Data in Snowflake