Trifacta wins the Best Data-Driven SaaS Product award at the 2021 Annual Cloud & SaaS Awards

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
All Templates

Work with Flows Using Public BigQuery Datasets

Bigquery Public Data – OpenStreetMap Flow The flow view of this template

Use OpenStreetMap data and generate value using Dataprep and BigQuery

array parsing (flatten, unnest), pivot, filtering (keep), rename

This template flow shows you how to work with OpenStreetMap data in public Bigquery datasets. It also illustrates several important Google Cloud Dataprep features such as custom SQL, flow and dataset parameterization.

This flow comes with detailed annotation of each step in the recipe. To use this template, follow the following steps:

1) Go to and type in a location you want to use as the center of your search. Make note of the latitude and longitude.

2) Follow the annotations in the flow and right click on the Openstreetmap data source and select “Edit Custom SQL” to see the parameters defined, and override the default latitude and longitude to what you have selected from step 1.

3) Choose the OSM parsing recipe and select “+” Create Output to run. Click “Run” to bring up additional configuration options. You can override all of the parameters that were defined in the data source in step 2. There’s also a new parameter called amenity that allows you to select the type of POIs (point of interest) such as restaurant, cafe, atm… etc. that you want to see in your output. You can also configure the distance to search in meters via the distance_meters parameter.

Fore more information, please check out this video demonstrating the use of this flow template in Google Cloud Dataprep.


You will be directed to Dataprep on Google Cloud. You can find this template on the product home page.

New to Dataprep?

Use the button above and start your 30-day free trial.

This template is not available on Trifacta.

Learn more about Dataprep