Set up Places Insights

In the Preview release, Places Insights provides city-specific data in BigQuery data clean rooms for the target countries. Data clean rooms provide a security-enhanced environment in which multiple parties can share, join, and analyze their data assets without moving or revealing the underlying data.

Before you can write SQL queries against the data in a clean room, 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 clean room for your target country.

Prerequisites

To access the Places Insights data in a clean room, you must:

1. Sign up to test 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 Subscriber (roles/analyticshub.subscriber) and Analytics Hub Subscription Owner (roles/analyticshub.subscriptionOwner) roles to perform subscriber tasks on the data clean rooms.

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

   For more information, see Additional subscriber permissions.

Subscribe to a data clean room

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

To subscribe to a clean room:

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) clean room:

   

3. Select the Subscribe button in the dialog.

4. 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 clean rooms

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