Set up Places Insights

In the Preview release, Places Insights provides city-specific data in BigQuery. Places Insights lets you enhance your own data with statistical insights about points of interest data to make more informed business decisions.

Before you can query Places Insights data, you must first sign up to get access to the Places Insights product. Once your account has been onboarded, you will be able to subscribe to the Places Insights dataset for your target country.

Prerequisites

To access the Places Insights data, you must:

1. Sign up to request access to Places Insights.

2. Have a Google Cloud account.

   If you don't have an account, click the Get Started button that links to an interactive setup experience in the Cloud console for new users:

   Get Started

3. Enable the BigQuery API. For instructions on enabling BigQuery and for a tutorial on using BigQuery, see Query a public dataset with the Google Cloud console.

4. Enable the Analytics Hub API.

5. Ensure that your account has the Analytics Hub Subscription Owner (roles/analyticshub.subscriptionOwner) role to perform subscriber tasks.

6. Ensure that your account has the BigQuery User (roles/bigquery.user) role to create datasets.

   For more information, see View and subscribe to listings.

Subscribe to the Places Insights dataset

Places Insights data is available for the cities and countries listed in the table below. Each city and country has its own data listing that you must subscribe to individually.

To subscribe to a listing:

1. Select the subscribe link for the city of interest from the table below.

2. A dialog opens for that country in the Google Cloud console. For example for the New York City, United States (US) listing:

   

3. Select the Subscribe button in the dialog.

4. Confirm or edit the Project, Linked dataset name, Primary region, and Replica regions in the dialog. You can choose to use the default listing name or you can optionally set the name to use your own naming convention.

   

5. Select Save.

6. When complete, the table subscription appears in the BigQuery Explorer panel in the Google Cloud console. In your SQL queries, use the table name shown below to access the data.

   

Available listings

The following table lists the supported cities and countries.

City, Country	Subscribe link	Table names
Sydney, Australia	AU	places_insights___au___sample.places_sample
Sao Paulo, Brazil	BR	places_insights___br___sample.places_sample
Toronto, Canada	CA	places_insights___ca___sample.places_sample
Paris, France	FR	places_insights___fr___sample.places_sample
Berlin, Germany	DE	places_insights___de___sample.places_sample
London, Great Britian	GB	places_insights___gb___sample.places_sample
Mumbai, India	IN	places_insights___in___sample.places_sample
Jakarta, Indonesia	ID	places_insights___id___sample.places_sample
Rome, Italy	IT	places_insights___it___sample.places_sample
Tokyo, Japan	JP	places_insights___jp___sample.places_sample
Mexico City, Mexico	MX	places_insights___mx___sample.places_sample
Madrid, Spain	ES	places_insights___es___sample.places_sample
Zurich, Switzerland	CH	places_insights___ch___sample.places_sample
New York City, United States	US	places_insights___us___sample.places_sample places_insights___us___sample.brands