​

About Coalesce Transform

Coalesce is a metadata-driven data transformation platform that helps data teams build and operate governed data pipelines on cloud data platforms. It combines visual DAG-based design with code editing capabilities, built-in governance, and column-level lineage tracking. Integrating Coalesce Transform with SYNQ enables you to:

• Monitor data pipeline health and execution status
• Track metadata changes across your transformation workflows
• Visualize data lineage from Coalesce pipelines to downstream assets
• Set up alerts on pipeline failures or data quality issues
• Correlate transformation runs with data warehouse changes

​

Set up Coalesce Transform integration

​

Step 1: Create integration in SYNQ

1. Navigate to Settings → Integrations → Add Integration
2. Select Coalesce Transform from the integration options

​

Step 2: Configure integration settings

​

Integration name

Enter a descriptive name for your integration (e.g., Production Coalesce or Coalesce Transform)

​

API endpoint

Select your Coalesce server region from the dropdown. Coalesce operates across multiple regions:

• US primary - https://app.us1.coalesce.io
• US secondary - https://app.us2.coalesce.io
• EU primary - https://app.eu1.coalesce.io
• EU secondary - https://app.eu2.coalesce.io
• Canada - https://app.ca1.coalesce.io
• Australia - https://app.au1.coalesce.io
• India - https://app.in1.coalesce.io
• UAE - https://app.ae1.coalesce.io
• UK - https://app.uk1.coalesce.io
• Singapore - https://app.sg1.coalesce.io

Choose the region that matches your Coalesce workspace. You can find your region by looking at the URL you use to access Coalesce.

​

API token

Generate an access token in your Coalesce Transform workspace:

1. Log into your Coalesce workspace
2. Navigate to the Deploy section
3. Click Generate Access Token
4. Copy the generated token immediately (you won’t be able to view it again)
5. Paste it into the API Token field in SYNQ

​

Project selection

After entering valid credentials, SYNQ will automatically load your available Coalesce projects. You can:

• Select specific projects by checking the boxes next to project names. Each project card displays:
  • Project name and description
  • Associated environment tags (Production, Staging, Development, etc.)
• Sync all projects by leaving all checkboxes unchecked. This is useful when you want SYNQ to automatically include new projects as they’re created in Coalesce.

​

Fetch interval

Configure how often SYNQ should poll Coalesce for updates. The default is 5 minutes. You can adjust this based on:

• Higher frequency (1-5 minutes): For production environments where you need near real-time monitoring
• Lower frequency (15-30 minutes): For development environments or when API rate limits are a concern

​

Step 3: Complete integration setup

1. Review your configuration settings
2. Click Create Integration
3. SYNQ will immediately begin syncing metadata from your Coalesce workspace

​

Verify integration

After creating the integration, you can verify it’s working correctly:

1. Navigate to Settings → Integrations
2. Find your Coalesce Transform integration in the list
3. Check the Last Sync timestamp to confirm data is being fetched
4. Navigate to Lineage to see Coalesce nodes and their relationships
5. Check that your Coalesce projects appear in the asset catalog

​

What data is synced?

When you connect Coalesce Transform to SYNQ, the following metadata is synchronized:

• Projects: All selected Coalesce projects and their configurations
• Environments: Development, staging, production, and custom environments
• Nodes: Sources, stages, dimensions, facts, views, and custom node types
• Job runs: Execution history, status, duration, and error messages
• Data lineage: Column-level lineage between nodes and downstream assets
• Storage mappings: Environment-specific database and schema configurations
• Metadata changes: Schema changes, node modifications, and deployment history

This metadata enables SYNQ to:

• Provide comprehensive lineage visualization
• Monitor pipeline execution health
• Alert on failures or anomalies
• Track data quality metrics across transformation workflows

​

Managing your integration

​

Edit integration settings

To modify your Coalesce Transform integration:

1. Navigate to Settings → Integrations
2. Find your Coalesce Transform integration
3. Click Edit
4. Update settings:
   • Change selected projects
   • Adjust fetch interval
   • Update API token (if rotated)
   • Switch regions (requires new API token)

​

Troubleshooting

​

Projects not loading

If projects don’t appear after entering your credentials:

1. Verify your API token is correct
2. Ensure the API endpoint matches your Coalesce region
3. Check that your token has the required read permissions
4. Try regenerating the token in Coalesce with appropriate permissions

​

Integration shows “Failed” status

Common causes and solutions:

• Invalid credentials: Regenerate your API token in Coalesce and update the integration
• Token expired: If your organization enforces token expiration, generate a new token
• Network issues: Ensure SYNQ can reach the Coalesce API endpoint (check firewalls if applicable)
• Permission changes: Verify the token still has read access to projects and environments

​

Missing metadata or lineage

If some Coalesce data isn’t appearing in SYNQ:

1. Check that the affected projects are selected in the integration configuration
2. Verify the projects have been deployed and have run history in Coalesce
3. Wait for the next sync cycle (based on your fetch interval)
4. Check the integration logs in Settings → Integrations → [Your Integration] → View Logs

​

Support

If you encounter issues or need assistance with your Coalesce Transform integration:

• Check the SYNQ Support documentation
• Contact SYNQ support through your shared Slack channel
• Reach out to the SYNQ team at [email protected]

For Coalesce-specific questions, consult the Coalesce documentation.