Find your BigQuery Credentials
Last updated
Last updated
To connect Humanic with your BigQuery data warehouse, you'll need to provide three pieces of information: the Project ID, Dataset ID, and a Service Account JSON key. Follow these steps to locate these credentials:
Sign in to the Google Cloud management console.
Navigate to the Dashboard of your project.
In the "Project info" section of the Dashboard, you'll find the Project ID displayed.
To find the Dataset ID, follow these steps in the BigQuery Studio:
In the "Explorer" panel, expand your project to view the list of datasets.
Locate the dataset you want to connect to Humanic.
You can find the Dataset ID in two ways: Option 1: Copy Dataset ID
Click on the three dots next to the dataset name.
Select "Copy ID" from the dropdown menu.
The Dataset ID will be copied to your clipboard.
Option 2: View Dataset Info
Click on the dataset name to open the "Dataset info" panel on the right.
The Dataset ID will be displayed in the "Dataset info" section.
To create a BigQuery service account key
Make sure that you have API enabled on your BigQuery API page. If you don’t see API Enabled, choose Enable.
On the Service accounts page, choose your BigQuery project, and then choose Create service account.
On the Service account details page, enter a descriptive value for Service account name. Choose Create and continue. The Grant this service account access to the project page opens.
Choose Continue, and then choose Done.
On the Service accounts page, choose the service account that you created.
On the Service Accounts page, click on the three dots next to the service account you just created and select "Manage Keys".
Click "Add Key" > "Create New Key".
Select "JSON" as the key type and click "Create". The JSON key file will be downloaded to your machine.
