View and subscribe to listings

As an Analytics Hub subscriber , you can view and subscribe to listings for which you have access. Subscribing to a listing creates a linked dataset in your project.

Required roles

To get the permissions that you need to use listings, ask your administrator to grant you the following Identity and Access Management (IAM) roles on the subscriber project:

• Discover listings : Analytics Hub Viewer ( roles/analyticshub.viewer )

• Subscribe to listings : BigQuery User ( roles/bigquery.user )

  • To subscribe to listings, you must also ask the listing publisher to grant you the Analytics Hub Subscriber role ( roles/analyticshub.subscriber ) on their listing, exchange, or project, whichever scope is most appropriate for your use case.

• View linked datasets : BigQuery Data Viewer ( roles/bigquery.dataViewer )

• Query linked datasets : BigQuery Data Viewer ( roles/bigquery.dataViewer )

• Update linked datasets : BigQuery Data Owner ( roles/bigquery.dataOwner )

• View table metadata : BigQuery Data Viewer ( roles/bigquery.dataViewer )

• Delete linked datasets : BigQuery Admin ( roles/bigquery.admin )

For more information about granting roles, see Manage access .

These predefined roles contain the permissions required to perform the tasks in this document. To see the exact permissions that are required to create and query datasets, expand the Required permissionssection:

You might also be able to get these permissions with custom roles or other predefined roles .

Discover listings

To discover public and private listings, follow these steps:

1. In the Google Cloud console, go to the Sharing (Analytics Hub)page.

   Go to Sharing (Analytics Hub)

2. Click Search listings. A dialog appears containing listings that you can access.

3. To filter listings by their name or description, enter the name or description of the listing in the Search for listingsfield.

4. In the Filterssection, you can filter listings based on the following fields:

   • Listings: select whether you want to view private listings, public listings, or listings within your org.

   • Categories: select one or more categories.

   • Location: select a location. You can only search by data exchange location. For more information, see Supported regions .

   • Provider: select the data provider. Some data providers require you to request access to their commercial datasets . After requesting access, the data provider contacts you to share their datasets.

5. Browse through the filtered listings.

Subscribe to listings

Subscribing to a listing gives you read-only accessto the data in the listing by creating a linked dataset in your project.

To subscribe to a listing, follow these steps:

POST https://analyticshub.googleapis.com/v1/projects/ PROJECT_ID 
/location/ LOCATION 
/dataExchanges/ DATAEXCHANGE_ID 
/listings/ LISTING_ID 
:subscribe

View linked datasets

Linked datasets are displayed together with other datasets in the Google Cloud console.

To view linked datasets in your project, follow these steps:

PROJECT=<your project ID> \
for dataset in $(bq ls --project_id $PROJECT | tail +3); do [ "$(bq show -d --project_id $PROJECT $dataset | egrep LINKED)" ] && echo $dataset; done

Query linked datasets

You can query tables and views in your linked datasets in the same way you would query any other BigQuery table .

Update linked datasets

Resources in a linked dataset are read-only . You can't edit the data or metadata for resources in linked datasets, or specify permissions for individual resources.

You can only update the description and labels of your linked datasets. Changes to a linked dataset don't affect the source or shared datasets.

To update the description and labels of a linked dataset, follow these steps:

1. In the Google Cloud console, go to the BigQuerypage.

   Go to BigQuery

2. In the Explorerpanel, click your project name, and then click the linked dataset.

3. Expand the more_vert Actionsoption and click Open.

4. In the Detailspanel, click mode_edit Edit detailsand then specify the following details:

   1. To add labels, see Adding a label to a dataset .

   2. To enable collation , expand the Advanced optionssection and follow these steps:

      1. Select Enable default collation.
      2. From the Default collationlist, select an option.

5. Click Save.

View table metadata

To view the underlying table metadata, query the INFORMATION_SCHEMA.TABLES view:

SELECT * FROM ` LINKED-DATASET 
.INFORMATION_SCHEMA.TABLES`

Replace LINKED-DATASET with the name of your linked dataset.

Unsubscribe from or delete linked datasets

To unsubscribe from a dataset, you must delete the linked dataset. Deleting a linked dataset doesn't delete the source dataset.

You cannot retrieve a linked dataset after you delete it. However, you can recreate the deleted linked dataset by subscribing to the listing again and adding the dataset and the linked datasets created from Google Cloud Marketplace-integrated listings to your project.

If your subscription is removed by an Analytics Hub publisher , then your linked dataset gets unlinked from the shared dataset . Since this is a publisher-initiated action on a subscriber-owned resource, the linked dataset remains dangling in the subscriber's project. The subscriber can remove the dangling dataset by deleting it.

To delete a linked dataset, do the following:

1. In the Google Cloud console, go to the BigQuerypage.

   Go to BigQuery

2. In the Explorerpanel, click your project name, and then click the linked dataset.

3. Expand the more_vert Actionsoption and click Delete.

4. In the Delete linked dataset?dialog, confirm deletion by typing delete.

5. Click Delete.

What's next

• Learn about BigQuery sharing .
• Learn about managing listings .
• Learn about managing data exchanges .
• Learn about BigQuery sharing audit logging .