TechPrufer
Get started
Google
Google logoGoogle · Feature trail

GeoIP Geolocation with BigQuery

1 post · Sep 2013 – Mar 2014

What this trail covers

This feature thread tracks the evolution of performing GeoIP geolocation lookups directly within Google BigQuery. It details how to leverage BigQuery's capabilities to enrich data with location information based on IP addresses, enabling more sophisticated data analysis and insights. This capability allows engineers to directly query and analyze location data without needing to export it to external systems for processing.

All Google trails
  1. Geoip geolocation with Google BigQuery- Google Developers BlogThis post details the technical approach for performing GeoIP geolocation lookups within Google BigQuery. It explains how to use BigQuery's SQL capabilities to join IP address data with GeoIP databases, thereby enriching datasets with country, region, and city information. The post likely provides example queries and discusses the performance implications of such operations within BigQuery.
  2. Visualizing airport delay correlations with Google BigQuery and Maps API- Google Developers BlogThis post details how to visualize airport delay correlations using Google BigQuery and the Maps API. It demonstrates how to join airport data with flight delay data and then visualize the results on a map, highlighting correlations between delays and geographical locations. This showcases the use of BigQuery for data analysis and the Maps API for visualization.