Third-Party Orchestration

Use third-party orchestration to trigger transformation runs in other platforms.

Overview

Fivetran integrates with several third-party transformations platforms so you can run sophisticated transformations while coordinating with Fivetran connections. We trigger transformations runs in your chosen platform according to either your connection syncs or a frequency-based schedule.

Supported platforms

We support the following transformations platforms:

• Coalesce.io* is Coalesce’s hosted transformations product, which includes features like a hybrid development environment and column lineage.
• dbt Cloud** is dbt Lab’s hosted transformations product, which includes features like a browser-based IDE and data lineage.

Setup guide

To trigger transformation runs from Fivetran, follow the setup guide for your chosen transformation platform:

• Coalesce Orchestration setup guide
• dbt Cloud Orchestration setup guide

Scheduling

Scheduling for third-party orchestration reflects standard transformation scheduling. In either case, you must select which Fivetran connections you want to trigger Coalesce or dbt Cloud jobs.

There are two scheduling options:

• Custom Scheduling: Run transformations on a set schedule, with the ability to specify a specific time of day for once-per-day runs.
• Integrated Scheduling: Trigger transformation runs based on selected connections' sync schedules.

Limitations

• You can only set up one project per destination. If you want to add an already-selected project to another destination, you must first remove it from the previous destination.
• If you use integrated scheduling, all connections that trigger a Coalesce or dbt Cloud job must be associated with the same destination.
• Connection syncs trigger Coalesce or dbt Cloud runs regardless of if new data lands with a sync.

Let us know if you would like to see more features by emailing us at james.hooker@fivetran.com.

* Coalesce is a trademark of Coalesce Automation, Inc. All rights therein are reserved to Coalesce Automation, Inc. Fivetran Transformations is not a product or service of or endorsed by Coalesce Automation, Inc.

** dbt Cloud is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.