Location from address Create a "Location" dimension in looker to plot on map from address string

[dudu_oren]

Hi,
I have a table in BigQuery with adresses in the US.
I would like to plot them in a map on Looker.

I had done it using the ZipCode (just parsed the adress string for it), but we require higher accuracy.
Is there a way to trnaslate the adrees to a location type?

Thanks

[Dawid · Accepted solution]

You would need latitude and longitude in your data in order to do it. If you don’t have it, you would need some kind of geocoding service to do it for you first and this way enrich your data. Looker doesn’t have such API nor any kind of geocoding, it only visualises data you have available in your warehouse.