Run the BigQuery Connector Externally

Learn how to Configure OpenMetadata’sBigtable database connector using YAML. Complete setup guide with examples, parameters, and best practices.

In this section, we provide guides and references to use the BigTable connector. Configure and schedule BigTable metadata and profiler workflows from the OpenMetadata UI:

• Requirements
• Metadata Ingestion

Requirements

Python Requirements

We have support for Python versions 3.9-3.11

To run the BigTable ingestion, you will need to install:

pip3 install "openmetadata-ingestion[bigtable]"

GCP Permissions

To execute metadata extraction and usage workflow successfully the user or the service account should have enough access to fetch required data. Following table describes the minimum required permissions

#	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

Create Custom GCP Role

Checkout this documentation on how to create a custom role and assign it to the service account.

Metadata Ingestion

1. Define the YAML Config

This is a sample config for BigTable:

2. Run with the CLI

First, we will need to save the YAML file. Afterward, and with all requirements installed, we can run:

metadata ingest -c <path-to-yaml>

Note that from connector to connector, this recipe will always be the same. By updating the YAML configuration, you will be able to extract metadata from different sources.