> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getcollate.io/llms.txt
> Use this file to discover all available pages before exploring further.

# BigTable Roles | Configure Access for Collate Connector

> Configure BigTable database roles and permissions in Collate connectors. Learn essential access control setup for seamless data cataloging and metadata extraction.

# Create custom role in GCP

This documentation will guide you on how to create a custom role in GCP with the necessary permissions to ingest BigTable in OpenMetadata.

## Step 1: Navigate to Roles

Search for `Roles` in your GCP console and select the first result under `IAM & Roles` section.

<img src="https://mintcdn.com/collatedocs/XRLyE3HymqoH13_i/public/images/connectors/bigtable/create-role-1.png?fit=max&auto=format&n=XRLyE3HymqoH13_i&q=85&s=e2cd9071ad14ecef6bedf475276503bb" alt="Navigate to Roles" width="1630" height="424" data-path="public/images/connectors/bigtable/create-role-1.png" />

## Step 2: Create Role & Add Permissions

Below the search bar you should see a `Create Role` button click on that & navigate to create role page.

<img src="https://mintcdn.com/collatedocs/XRLyE3HymqoH13_i/public/images/connectors/bigtable/create-role-2.png?fit=max&auto=format&n=XRLyE3HymqoH13_i&q=85&s=2df51a4c08c2e29faecd7db494237458" alt="Create Role Button" width="1642" height="370" data-path="public/images/connectors/bigtable/create-role-2.png" />

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.

<img src="https://mintcdn.com/collatedocs/XRLyE3HymqoH13_i/public/images/connectors/bigtable/create-role-3.png?fit=max&auto=format&n=XRLyE3HymqoH13_i&q=85&s=4d6ff8d0c75d7e87ed2f32c032f7a9df" alt="Create Role" width="1120" height="1006" data-path="public/images/connectors/bigtable/create-role-3.png" />

You can search for the required permissions in the filter box and add them accordingly. To ingest metadata from BigTable you need to grant the following permissions to the user.

| #  | GCP Permission           | Required For       |
| :- | :----------------------- | :----------------- |
| 1  | bigtable.instances.get   | Metadata Ingestion |
| 2  | bigtable.instances.list  | Metadata Ingestion |
| 3  | bigtable.tables.get      | Metadata Ingestion |
| 4  | bigtable.tables.list     | Metadata Ingestion |
| 5  | bigtable.tables.readRows | Metadata Ingestion |

<img src="https://mintcdn.com/collatedocs/XRLyE3HymqoH13_i/public/images/connectors/bigtable/create-role-4.png?fit=max&auto=format&n=XRLyE3HymqoH13_i&q=85&s=e679aa63f7f77cbe27a85e859f6e4218" alt="Add Permissions" width="1058" height="566" data-path="public/images/connectors/bigtable/create-role-4.png" />

Once you have added all the required permissions, you can create the role by clicking on the create button.

## Step 3: Assign Role to Service Account

To assign the created role, you can navigate to `IAM` and click on `Grant Access` and you can search your service account in the `Add Principals` section & Assign the created role to the service account.

<img src="https://mintcdn.com/collatedocs/XRLyE3HymqoH13_i/public/images/connectors/bigtable/create-role-5.png?fit=max&auto=format&n=XRLyE3HymqoH13_i&q=85&s=83b330dbb21500acc3c2bfd5ee5ec33e" alt="Add Permissions" width="1106" height="968" data-path="public/images/connectors/bigtable/create-role-5.png" />
