1. Set Up a Google Cloud Platform (GCP) Project
• Navigate to the Google Cloud Console and create a new project or use an existing
one.
• Note down the Project ID as it will be required.
2. Enable the BigQuery API
• Go to the API Library in the Google Cloud Console.
• Search for “BigQuery API” and enable it for your project.
3. Create a Service Account
To configure a service account in the BigQuery console, follow these steps:
• Navigate to IAM & Admin > Service Accounts.
• Click on Create Service Account.
• Add Name, ID, Description, then click Create and Continue.
• In the optional account access field, select the role BigQuery Admin.
4. Create the Service Account Key
After creating the service account, download the key file in JSON format:
1. Click on Actions -> Manage Keys for the service account.
2. Click on ADD KEY -> Create new key.
3. Download the JSON key file.
5. Create Dataset, Schema, and Tables
1. Go to the BigQuery Console.
2. In the Explorer pane, select your project.
3. Click on the Create Dataset button.
4. Provide a Dataset ID, select a Data Location, and configure other optional settings
(e.g., expiration time, encryption).
5. Click Create Dataset.
6. Open the dataset you created to view its details in the right pane.
7. Click on Create Table to create a schema and tables. Define column names, data
types, and other settings as required.
8. Look for the Location or Region field in the dataset details. Note down the location
( e.g., US, EU, asia-east1), as it will be required later.
Google Cloud BigQuery Database Configuration on Gathr:
To configure Google Cloud BigQuery Database, follow the steps below:-
1. Select ' BigQuery' from drop down menu of 'Database Type'. If it is already present
then ignore.
2. Enter your Server IP and Server Port.
3. Enter the Project Id .
4. Enter the BigQuery Region obtained from Step 5 (#8). Add “region-” before your
region name (e.g., region-us, region-asia-east1).
5. Select “Create New Account” from the "Add Account" drop down menu.
6. Add user friendly name for account, for example “Google Cloud BigQuery Account”.
7. Enter Service Account Email .
8. Paste the complete content of the JSON key file into the Service Account Key field.
9. Click on "Save" button