This guide will walk you through how to connect Coalesce Quality with Coalesce Catalog (formerly Castordoc). The integration allows bidirectional metadata synchronization between the two platforms.To finish this guide, you’ll need the following:
→ Admin access to your Coalesce Quality workspace
→ Admin access to your Coalesce Catalog workspace⏱️ Estimated time to finish: 15 minutes.
→ Admin access to your Coalesce Quality workspace
→ Admin access to your Coalesce Catalog workspace⏱️ Estimated time to finish: 15 minutes.
Integration
Coalesce Catalog is a data catalog. This integration links Catalog assets to Coalesce Quality assets and shows their quality status in the catalog. The integration is bidirectional: From Coalesce Catalog to Coalesce Quality:- Pulls all catalog entities (tables, dashboards, etc.) and maps them to the matching Coalesce Quality assets
- This ensures that assets in both platforms are linked, providing a unified view across your data stack
- Reports monitor status, test results, and asset health as Data Qualities in your catalog
- Supports both table-level and column-level quality reporting
Setup guide
Name your integration
For exampleCoalesce Catalog or Production Catalog
Select the region
Select your Coalesce Catalog region from the dropdown:- Rest of World (EU): https://app.castordoc.com/
- United States: https://app.us.castordoc.com/
Enter the API token
Generate an API token in your Coalesce Catalog settings and paste it into the API token field. The token needs read access to list your sources, and write access to Data Qualities. Treat it as a secret.Select sources
The From Coalesce Catalog section lists the sources of your Catalog account. Turn on each source you want to ingest. For each enabled warehouse source you can select a Coalesce Quality data warehouse mapping. This is optional, as Coalesce Quality matches tables from the catalog metadata by itself. Select a mapping only for warehouses that Coalesce Quality identifies by account or host, such as Snowflake. One Coalesce Catalog integration covers all your warehouses. Fetch interval (hours) sets how often Coalesce Quality reads metadata from Coalesce Catalog. The default is 6 hours. If the account has a Coalesce Transform source, also set up the Coalesce Transform integration for full lineage and run tracking.Configure sync to Coalesce Catalog
The To Coalesce Catalog section controls what Coalesce Quality writes to your catalog:- Sync asset links: adds links to Coalesce Quality assets in Coalesce Catalog.
- Sync data quality tests: pushes Coalesce Quality checks to Coalesce Catalog as Data Quality tests. You can limit the sync to specific assets. Leave the filter empty to sync all assets.
- Upload interval (minutes): how often Coalesce Quality uploads to Coalesce Catalog. The default is 30 minutes.
What data is synced?
Catalog entities (Catalog to Coalesce Quality)
Coalesce Quality reads catalog entities and maps them to the matching assets:- Tables and views
- Dashboards and reports
- Other catalog entries
Data Qualities (Coalesce Quality to Catalog)
The platform uploads data quality information to your catalog as Data Qualities, which appear on your catalog entries: Table-level qualities:- Monitor status (passing, failing, warning)
- Test results from transformation layer tests (dbt, SQLMesh, Coalesce Transform) and custom SQL tests
- Freshness and volume health indicators
- Overall asset health status
- Column-specific monitor results
- Field-level test outcomes
- Column health indicators
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 need to change the region?
You cannot change the region of an existing integration. Delete the integration and create a new one with the right region and an API token from that region.What if sources don’t load?
- Verify your API token is correct and has read permissions
- Ensure the region matches your Coalesce Catalog workspace
- Check that sources are configured in your Coalesce Catalog