Run the dbt Cloud Connector Externally

Learn how to Configure OpenMetadata’sdbt Cloud connector using YAML. Step-by-step setup guide for seamless data pipeline integration and metadata extraction.

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

• Requirements
• Metadata Ingestion

Requirements

Python Requirements

We have support for Python versions 3.9-3.11

Metadata Ingestion

All connectors are defined as JSON Schemas. Here you can find the structure to create a connection to dbt cloud. In order to create and run a Metadata Ingestion workflow, we will follow the steps to create a YAML configuration able to connect to the source, process the Entities if needed, and reach the OpenMetadata server. The workflow is modeled around the following JSON Schema

1. Define the YAML Config

This is a sample config for dbt Cloud:

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.