If you're OK with country level only, I've found [fh-bigquery:geocode.geolit...

If you're OK with country level only, I've found [fh-bigquery:geocode.geolite_country_bq] to perform faster. Your query on your main table should look... - Michael Lugassy - Google+