BigQuery data share

Send this to Aampe

• Service account email, in the form aampe-data-share@YOUR_PROJECT_ID.iam.gserviceaccount.com
• The BigQuery region you query from, such as US or us-central1

1. Prepare your project

1. Turn on billing.
2. Enable the BigQuery API.
3. Enable the Analytics Hub API.

2. Create a service account

1. Open Service accounts for that project.
2. Click Create service account.
3. Name it aampe-data-share.
4. Copy the email address.

3. Grant roles on your project

• BigQuery User (roles/bigquery.user), so it can create the linked dataset and run queries
• BigQuery Data Viewer (roles/bigquery.dataViewer), so it can read the shared tables

1. Open IAM.
2. Click Grant access.
3. Paste the service account email.
4. Add both roles and save.

4. Subscribe once

SA=aampe-data-share@YOUR_PROJECT_ID.iam.gserviceaccount.com

curl -sS -X POST \
  -H "Authorization: Bearer $(gcloud auth print-access-token --impersonate-service-account="$SA")" \
  -H "Content-Type: application/json" \
  "https://analyticshub.googleapis.com/v1/projects/PUBLISHER_PROJECT/locations/LOCATION/dataExchanges/DATA_EXCHANGE_ID/listings/LISTING_ID:subscribe" \
  -d '{
    "destinationDataset": {
      "datasetReference": {
        "projectId": "YOUR_PROJECT_ID",
        "datasetId": "aampe"
      },
      "location": "LOCATION"
    }
  }'

5. Query

SELECT *
FROM `YOUR_PROJECT_ID.aampe.TABLE_NAME`
LIMIT 10;