Coalesce Orchestration Beta

Use Coalesce/* Orchestration to trigger transformation runs from Fivetran.

Overview

Fivetran integrates with Coalesce so that you can trigger job runs based on your connector syncs or a frequency-based schedule. Coalesce.io is Coalesce’s hosted transformations product that lets you run sophisticated transformations. Orchestration allows you to take advantage of Coalesce jobs, projects while coordinating with Fivetran connectors.

Setup guide

Follow our step-by-step Coalesce Orchestration setup guide to trigger transformation runs from Fivetran.

Scheduling

Scheduling with Coalesce reflects transformation scheduling. Our Coalesce-integrated scheduler requires you to select the connectors you want to trigger Coalesce jobs, versus our Coalesce scheduler, which infers associated connectors automatically.

There are two types of available scheduling that work in a similar way to the dbt Cloud scheduling:

• 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 connectors' sync schedules.

Limitations

• You can only set up a single project per destination. If you want to set up an already selected project on another destination, you must first remove it from the previous one.
• Integrated scheduling requires that all connectors that are triggering a Coalesce job be associated with the same destination.
• Connector syncs trigger Coalesce 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.