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

Fivetran HVR

Fivetran is an enterprise data integration platform that automates data pipelines from sources to destinations. The Fivetran HVR sink exposes a webhook-compatible endpoint that speaks Fivetran's HVR (High Volume Replication) format, allowing pg_tide to deliver events in a format that Fivetran's infrastructure can consume and route to any Fivetran-supported destination.

When to Use This Sink

Choose the Fivetran sink when your organization uses Fivetran as its primary data integration platform and you want pg_tide events to flow through Fivetran's managed pipeline infrastructure for delivery to final destinations.

Configuration

SELECT tide.relay_set_outbox(
    'events-to-fivetran',
    'events',
    'fivetran-relay',
    '{
        "sink_type": "fivetran",
        "endpoint_url": "${env:FIVETRAN_WEBHOOK_URL}",
        "api_key": "${env:FIVETRAN_API_KEY}",
        "api_secret": "${env:FIVETRAN_API_SECRET}",
        "batch_size": 100
    }'::jsonb
);

Configuration Reference

ParameterTypeDefaultDescription
sink_typestringMust be "fivetran"
endpoint_urlstringFivetran HVR endpoint URL
api_keystringFivetran API key
api_secretstringFivetran API secret
batch_sizeint100Records per webhook batch

Further Reading

  • Singer / Meltano — Open-source alternative with ~500 connectors
  • Airbyte — Open-source alternative with ~400 connectors