Connecting to BigQuery
BigQuery is Google Cloud’s fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data in near real time.
Connect Publisher to BigQuery to access and share your Google Cloud Platform data. This process requires specific Google Cloud credentials and project information.
Prerequisites
Before starting, you will need:
A Google service account with appropriate data access
The service account key in JSON format
Google Cloud Platform project ID
Google Cloud Platform quota project ID
Name of the target BigQuery dataset
Creating Service Account Keys
To obtain the required credentials:
Access the Google Cloud Platform Console's API Credentials section
Create a new service account or use an existing one with appropriate data access
Navigate to the KEYS tab
Select ADD KEY and choose "Create new key"
Select JSON as the key type
You can read more how to create Google Service account keys here
Configuration Process
Initial Setup
Access the Data Sources page through Publisher's navigation sidebar and select "Connect Data Source". Choose "BigQuery Database" from the available connectors.
Service Account Configuration
Upload your Google service account key:
Drag and drop the JSON file or use the upload icon
Enter your Google Cloud Platform project ID
Provide the quota project ID
Dataset Selection
Select the appropriate dataset from the dropdown menu containing your target data.
Finalizing Setup
Provide a descriptive name for your data source. After successful connection, you can optionally create and share a collection on Networks using the "Share Collection" option.
Last updated