2024-06-18 15:53:06 +02:00
|
|
|
---
|
|
|
|
title: Run the Airbyte Connector Externally
|
|
|
|
slug: /connectors/pipeline/airbyte/yaml
|
|
|
|
---
|
|
|
|
|
|
|
|
{% connectorDetailsHeader
|
|
|
|
name="Airbyte"
|
|
|
|
stage="PROD"
|
|
|
|
platform="OpenMetadata"
|
2025-03-13 13:58:04 +05:30
|
|
|
availableFeatures=["Pipelines", "Pipeline Status", "Lineage", "Usage"]
|
2024-06-18 15:53:06 +02:00
|
|
|
unavailableFeatures=["Owners", "Tags"]
|
|
|
|
/ %}
|
|
|
|
|
|
|
|
In this section, we provide guides and references to use the Airbyte connector.
|
|
|
|
|
|
|
|
Configure and schedule Airbyte metadata and profiler workflows from the OpenMetadata UI:
|
|
|
|
|
|
|
|
- [Requirements](#requirements)
|
|
|
|
- [Metadata Ingestion](#metadata-ingestion)
|
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/external-ingestion-deployment.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
|
|
|
## Requirements
|
|
|
|
|
|
|
|
### Python Requirements
|
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/python-requirements.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
|
|
|
To run the Airbyte ingestion, you will need to install:
|
|
|
|
|
|
|
|
```bash
|
|
|
|
pip3 install "openmetadata-ingestion[airbyte]"
|
|
|
|
```
|
|
|
|
|
|
|
|
## Metadata Ingestion
|
|
|
|
|
|
|
|
All connectors are defined as JSON Schemas.
|
|
|
|
[Here](https://github.com/open-metadata/OpenMetadata/blob/main/openmetadata-spec/src/main/resources/json/schema/entity/services/connections/pipeline/airbyteConnection.json)
|
|
|
|
you can find the structure to create a connection to Airbyte.
|
|
|
|
|
|
|
|
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](https://github.com/open-metadata/OpenMetadata/blob/main/openmetadata-spec/src/main/resources/json/schema/metadataIngestion/workflow.json)
|
|
|
|
|
|
|
|
### 1. Define the YAML Config
|
|
|
|
|
|
|
|
This is a sample config for Airbyte:
|
|
|
|
|
|
|
|
{% codePreview %}
|
|
|
|
|
|
|
|
{% codeInfoContainer %}
|
|
|
|
|
|
|
|
#### Source Configuration - Service Connection
|
|
|
|
|
|
|
|
{% codeInfo srNumber=1 %}
|
|
|
|
|
|
|
|
**hostPort**: Pipeline Service Management UI URL
|
|
|
|
|
2025-01-07 12:41:56 +05:30
|
|
|
{% /codeInfo %}
|
|
|
|
|
|
|
|
{% codeInfo srNumber=2 %}
|
|
|
|
|
|
|
|
**username**: Username to connect to Airbyte.
|
|
|
|
|
|
|
|
{% /codeInfo %}
|
|
|
|
|
|
|
|
{% codeInfo srNumber=3 %}
|
|
|
|
|
|
|
|
**password**: Password to connect to Airbyte.
|
|
|
|
|
|
|
|
{% /codeInfo %}
|
|
|
|
|
|
|
|
{% codeInfo srNumber=4 %}
|
|
|
|
|
|
|
|
**apiVersion**: Version of the Airbyte REST API by default `api/v1`.
|
2024-06-18 15:53:06 +02:00
|
|
|
|
|
|
|
{% /codeInfo %}
|
|
|
|
|
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/yaml/pipeline/source-config-def.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/yaml/ingestion-sink-def.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/yaml/workflow-config-def.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
|
|
|
|
|
|
|
{% /codeInfoContainer %}
|
|
|
|
|
|
|
|
{% codeBlock fileName="filename.yaml" %}
|
|
|
|
|
|
|
|
|
|
|
|
```yaml {% isCodeBlock=true %}
|
|
|
|
source:
|
|
|
|
type: airbyte
|
|
|
|
serviceName: airbyte_source
|
|
|
|
serviceConnection:
|
|
|
|
config:
|
|
|
|
type: Airbyte
|
|
|
|
```
|
|
|
|
```yaml {% srNumber=1 %}
|
|
|
|
hostPort: http://localhost:8000
|
|
|
|
```
|
2025-01-07 12:41:56 +05:30
|
|
|
```yaml {% srNumber=2 %}
|
|
|
|
username: <username>
|
|
|
|
```
|
|
|
|
```yaml {% srNumber=3 %}
|
|
|
|
password: <password>
|
|
|
|
```
|
|
|
|
```yaml {% srNumber=4 %}
|
|
|
|
apiVersion: api/v1
|
|
|
|
```
|
2024-06-18 15:53:06 +02:00
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/yaml/pipeline/source-config.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/yaml/ingestion-sink.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/yaml/workflow-config.md" /%}
|
2024-06-18 15:53:06 +02:00
|
|
|
|
|
|
|
{% /codeBlock %}
|
|
|
|
|
|
|
|
{% /codePreview %}
|
|
|
|
|
2024-12-12 11:34:09 +05:30
|
|
|
{% partial file="/v1.7/connectors/yaml/ingestion-cli.md" /%}
|