Keyboard shortcuts

Press or to navigate between chapters

Press S or / to search in the book

Press ? to show this help

Press Esc to hide this help

Source: Airbyte

The Airbyte source runs Airbyte source connectors (as Docker containers) and delivers extracted records into a pg_tide inbox. This provides access to approximately 400 data sources from the Airbyte connector catalog.

Configuration

SELECT tide.relay_set_inbox(
    'salesforce-data',
    'crm_inbox',
    '{
        "source_type": "airbyte",
        "source_image": "airbyte/source-salesforce:latest",
        "source_config": {
            "client_id": "${env:SF_CLIENT_ID}",
            "client_secret": "${env:SF_CLIENT_SECRET}",
            "refresh_token": "${env:SF_REFRESH_TOKEN}"
        },
        "streams": ["contacts", "opportunities"]
    }'::jsonb
);

Configuration Reference

ParameterTypeDefaultDescription
source_typestringMust be "airbyte"
source_imagestringDocker image for the Airbyte source connector
source_configobject{}Connector configuration
streamsarraynullStreams to sync (null = all discovered)
sync_modestring"incremental"Sync mode: "incremental" or "full_refresh"

Further Reading