Create Credentials for BigQuery Ingestion
This documentation provides a step-by-step guide on how to create a custom role in Google Cloud Platform (GCP) with the necessary permissions to ingest BigQuery in OpenMetadata. It covers the process of navigating to the Roles section in the GCP console, creating a role, adding permissions, and creating a service account with credentials. By following these instructions, you will be able to set up the required role and credentials to access and ingest BigQuery metadata in OpenMetadata. Let’s get started!1. Create custom role in GCP
Step 1: Navigate to Roles
Search forRoles in your GCP console and select the first result under IAM & Roles section.
Step 2: Create Role & Add Permissions
Below the search bar you should see aCreate Role button click on that & navigate to create role page.
Once You are on the create role page, you can edit the description & title of the role and finally you can click on add permissions to grant permissions to role.
You can search for the required permissions in the filter box and add them accordingly. To ingest metadata from BigQuery you need to grant the following permissions to the user.
Once you have added all the required permissions, you can create the role by clicking on the create button.
2. Create Service Account
Step 1: Navigate to Service Accounts
Login to your GCP console and navigate to service accounts page.Step 2: Create Service Account & Grant Role
Once you are on service account page, click onCreate Service Account button.
Fill the service account details
Grant a role to service account which has all the required permission to ingest BigQuery metadata in OpenMetadata.