Skip to main content
This guide will walk you through how to set up SYNQ integration with Coalesce Catalog (formerly Castordoc). The integration allows bidirectional metadata synchronization between SYNQ and Coalesce Catalog.To finish this guide, you’ll need the following:
→ Admin access to your SYNQ workspace
→ Admin access to your Coalesce Catalog workspace
→ At least one data warehouse integration configured in SYNQ (for warehouse mappings)⏱️ Estimated time to finish: 15 minutes.

​
Integration

Coalesce Catalog is a data catalog solution that helps organizations discover, understand, and govern their data assets. This integration connects your Coalesce Catalog with SYNQ to provide a unified view of your data assets and their health. The integration is bidirectional: From Coalesce Catalog to SYNQ:
  • Pulls all catalog entities (tables, dashboards, etc.) and maps them to corresponding SYNQ assets
  • This ensures that assets in both platforms are linked, providing a unified view across your data stack
From SYNQ to Coalesce Catalog:
  • Reports monitor status, test results, and asset health as Data Qualities in Coalesce Catalog
  • Supports both table-level and column-level quality reporting
  • Keeps your catalog enriched with real-time data quality information

​
Setup guide

​
Name your integration

For example Coalesce Catalog or Production Catalog

​
Select the region

Select your Coalesce Catalog region from the dropdown: Choose the region that matches your Coalesce Catalog workspace. You can determine your region by looking at the URL you use to access Coalesce Catalog.

​
Generate a token

Coalesce Catalog API tokens are managed by your organization’s Catalog ops team
  1. Contact your Coalesce Catalog ops team to request an API token
  2. Ensure the token has appropriate read and write permissions for metadata synchronization
  3. Store the token securely in a secrets manager — never commit tokens to version control
Store your API token securely. Coalesce Catalog tokens provide access to your workspace metadata and should be treated as sensitive credentials.

​
Configure sync intervals

​
Fetch interval (hours)

How often SYNQ should fetch catalog entities from Coalesce Catalog. Default: 2 hours This controls how frequently SYNQ pulls tables, dashboards, and other catalog entries to map them with SYNQ assets.

​
Upload interval (minutes)

How often SYNQ should upload Data Qualities to Coalesce Catalog. Default: 30 minutes This controls how frequently SYNQ pushes monitor status, test results, and asset health information to your catalog entries.

​
Configure warehouse mappings

Warehouse mappings connect your Coalesce Catalog warehouses to your SYNQ data warehouse integrations. This enables SYNQ to correlate assets between platforms.
You must have at least one data warehouse integration (BigQuery, Snowflake, Databricks, etc.) configured in SYNQ before you can add warehouse mappings.
To add a warehouse mapping:
  1. Click Add Warehouse Mapping
  2. Select a Coalesce Warehouse from the dropdown (or enter the warehouse ID manually if not listed)
  3. Select the corresponding SYNQ Data Warehouse integration
  4. The Mapping Name is auto-generated based on your selections, but you can customize it
You can add multiple warehouse mappings to connect all your Coalesce Catalog warehouses with their corresponding SYNQ integrations.

​
What data is synced?

​
Catalog entities (Coalesce Catalog → SYNQ)

SYNQ pulls catalog entities and maps them to corresponding SYNQ assets:
  • Tables and views
  • Dashboards and reports
  • Other catalog entries
This mapping ensures that when you view an asset in SYNQ, it’s linked to the same asset in Coalesce Catalog, providing a unified experience across both platforms.

​
Data Qualities (SYNQ → Coalesce Catalog)

SYNQ uploads data quality information to Coalesce Catalog as Data Qualities, which appear on your catalog entries: Table-level qualities:
  • Monitor status (passing, failing, warning)
  • Test results from dbt tests and SYNQ SQL tests
  • Freshness and volume health indicators
  • Overall asset health status
Column-level qualities:
  • Column-specific monitor results
  • Field-level test outcomes
  • Column health indicators
This enables your data consumers to see data quality status directly in Coalesce Catalog without needing to access SYNQ.

​
FAQ

​
What access do you require?

We require write access to Data Qualities via the Coalesce Catalog Public API. The token also needs read access to list available warehouses during configuration. We don’t access raw data in your data warehouse through this integration.

​
What if I change regions?

If you change the region, you must provide a new API token for that region. Tokens are region-specific and cannot be used across different Coalesce Catalog regions.

​
What if warehouses don’t appear in the dropdown?

If warehouses don’t load:
  1. Verify your API token is correct and has read permissions
  2. Ensure the region matches your Coalesce Catalog workspace
  3. Check that warehouses are configured in your Coalesce Catalog
  4. You can manually enter the warehouse UUID if the dropdown doesn’t populate

​
How are Data Qualities displayed in Coalesce Catalog?

SYNQ creates Data Quality entries that appear on your table and column pages in Coalesce Catalog. These show the current status of monitors and tests, allowing catalog users to quickly assess data health.