IPinfo on Google Cloud Platform

This document explores how to use our IP database within the Google Cloud Platform (GCP)'s data warehouse platform, BigQuery, delivered through Google Marketplace.

IPinfo Datasets available on Google Cloud Platform

The GCP integration allows our users to access the following features:

• Automatic loading into BigQuery: No need for custom scripts; data is automatically loaded into BigQuery.
• Built-in metadata: Tracks updates and ensures data freshness.
• Efficient query functions: Ready-to-use, highly optimized query functions with clear documentation.
• Centralized data: Simplifies IP data enrichment across other datasets and logs in BigQuery.

Just like our Cloud Data Push and Snowflake datasets, we keep your GCP IP datasets in your BigQuery environment up to date with regular updates — you don’t need to do anything after the initial subscription. The data you query on your BQ environment is the latest data we have!

Available Datasets

We offer our IPinfo Lite database through the Google Cloud Analytics Hub platform, but for our premium databases like IPinto Core, IPinfo Plus, and any custom IP databases, we offer them through the Google Cloud Marketplace. Getting started only takes a click of a button.

IP Database	Region	Access	Features
IPinfo Lite	US / Default	Self Serve – Free	Accurate country and ASN info for free—no fees, no credit card, and unlimited usage.
	EU
IPinfo Core	US / Default	Self Serve - Premium	Provides city-level accuracy along with key IP privacy details, such as VPN, hosting, satellite, and carrier detection.
	EU
IPinfo Plus	US / Default		Comprehensive IP data with detailed context, including service classifications, confidence scores, and stability metrics.
	EU
Any IP database	Any Region / Any Data	On Request	Any and all IP data available to be offered by IPinfo.

Features

IPinfo BigQuery Datasets

Customers can access IPinfo IP data in BigQuery in the following ways:

Database Type	Source	Access
IPinfo Lite (Free)	Available on GCP Analytics Hub	Self-serve
IPinfo Core and Plus	Available on Google Cloud Marketplace	Self-serve
Custom IP Datasets	Contact sales team via listing form	Contact to purchase

IP Lookup Mechanism

IP datasets require specialized solutions to look up IP addresses. We recommend using our lookup method instead of building your own, as it’s optimized for the best performance. Our query functions support both IPv4 and IPv6 and offer an extremely efficient and easy-to-use solution.

Database	Dataset Name	Table	Query Function
IPinfo Lite	lite	lite	lite
IPinfo Lite – EU	lite_eu
IPinfo Core	core	core	core
IPinfo Core – EU	core_eu
IPinfo Plus	plus	plus	plus
IPinfo Plus – EU	plus_eu

Bringing log data from Cloud Logging

As the IPinfo data resides in BigQuery, you can bring in log data from GCP Cloud Logging and perform IP metadata enrichment (geolocation, privacy, ASN, etc.) inside BigQuery. We recommend checking the documentation provided by Google. Visit View logs routed to BigQuery.

We recommend ensuring that only distinct IP addresses are enriched instead of all the IP addresses in a log.

SELECT ip, ipinfo_lite.lite(ip)
FROM (SELECT DISTINCT ip FROM my_ips)

As Cloud Logging supports many different sources, IPinfo's data inside BigQuery acts as a powerful data enrichment and analytics platform.

IPinfo Lite database on GCP BigQuery

IPinfo's Lite data is available on Google Cloud Analytics Hub:

• IPinfo Lite
• IPinfo Lite - EU Region

Resources included

The IPinfo Lite BigQuery Dataset contains the following resources:

Resources	Type	Description
lite	TABLE	The main IPinfo Lite Dataset. Full accuracy and daily updated (from our end).
ip_sample	TABLE	Sample of IP addresses to test out queries and learn.
lite (available in routines)	FUNCTION	Query function, lookup IP address against the IP table
gen_ranges (available in routines)	FUNCTION	Helper function used to support the Query function

Using the lite query function

We include a IP lookup function with our BigQuery datasets. It’s located in the dataset’s routine directory and shares the same name as the IP data table. No custom code is needed to start using it.

Example:

SELECT
    ip,
    ipinfo_lite.lite(ip) as lite
FROM 
    ipinfo_lite.ip_sample;

Code notes:

• ip_sample holds some random IP addresses.
• lite() is the UDF packaged with the dataset. The UDF name matches the dataset name, with () indicating it's a function.

Besides getting all the data at once, you can also specify individual columns of data that you need.

SELECT
    ip,
    ipinfo_lite.lite(ip).country as lite
FROM 
    ipinfo_lite.ip_sample;

IPinfo Core, IPinfo Plus, and other data on GCP Analytics Hub

Other than our IPinfo Lite database, we also have our data in Google Cloud Marketplace. The databases themselves come with our query UDF, and there is no friction to get started today.

---

We welcome your feedback and if you have any feature requests or need support using the BQ IPinfo dataset, please create a post in our IPinfo Community.