Coalesce
Low-code Data Transformation Tool built on Snowflake
Type: Transformation
Website: https://coalesce.io/
API Docs: https://docs.coalesce.io/reference
Authentication
Authentication to Coalesce is straightforward, and requires you to Generate an Access Token that Orchestra uses to communicate to Coalesce with. In order to do this, you also need to ensure that within the User Credentials section in Coalesce that "Snowflake OAuth" is selected for your environment
Authentication Instructions
Prerequisites
To connect to Coalesce, you will need:
A Coalesce account
A Snowflake account
Configuring OAuth in Coalesce
Orchestra requires that your Coalesce environment is connected to your Snowflake account via OAuth. The documentation in Coalesce can help with this.
Make sure in User Credentials that Snowflake OAuth is selected for your environment, and that it has successfully authenticated:
Generate Access Token
Head over to
Deployin CoalesceSelect "Generate Access Token"
Copy this value and store it somewhere safe. This is your Access Token
Copy the value highlighted in the box below
Jobs
| Job name | Description |
|---|---|
Run job | Triggers a Coalesce refresh job to run using this endpoint |
Metadata
There are a number of advanced features within the Coalesce integration around deployment events and lineage and cost that are extremely powerful
Deployment events
You can fetch deployment events from Coalesce to ensure that when something runs, you can see what the latest deployment was. This helps for debugging, as users can easily see if a recent deployment is the cause of failure for a refresh job
Snowflake Metadata (cost)
Under the relevant Coalesce Run job, you can select a Snowflake Connection to use to fetch additional metadata to enrich your Coalesce tasks.
This allows you to view Snowflake Credit cost per query run from Coalesce
End to end lineage
Rather than render a single node in the lineage graph, the Orchestra Coalesce integration appropriately displays an asset-based view of operations that occur from Coalesce under-the-hood
Last updated
