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
→ At least one data warehouse integration configured in the platform (for warehouse mappings)⏱️ Estimated time to finish: 15 minutes.
→ Admin access to your Coalesce Quality workspace
→ Admin access to your Coalesce Catalog workspace
→ At least one data warehouse integration configured in the platform (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 Catalog and quality workspaces to provide a unified view of your data assets and their health. The integration is bidirectional: From Catalog to quality:- Pulls all catalog entities (tables, dashboards, etc.) and maps them to corresponding 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
- Keeps your catalog enriched with real-time data quality information
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/
Generate a token
Coalesce Catalog API tokens are managed by your organization’s Catalog ops team
- Contact your Coalesce Catalog ops team to request an API token
- Ensure the token has appropriate read and write permissions for metadata synchronization
- Store the token securely in a secrets manager — never commit tokens to version control
Configure sync intervals
Fetch interval (hours)
How often the platform should fetch catalog entities from Coalesce Catalog. Default: 2 hours This controls how frequently the platform pulls tables, dashboards, and other catalog entries to map them with your quality assets.Upload interval (minutes)
How often the platform should upload Data Qualities to your Catalog workspace. Default: 30 minutes This controls how frequently the platform pushes monitor status, test results, and asset health information to your catalog entries.Configure warehouse mappings
Warehouse mappings connect your Catalog warehouses to your data warehouse integrations. This enables the platform to correlate assets between both systems.You must have at least one data warehouse integration (BigQuery, Snowflake, Databricks, etc.) configured before you can add warehouse mappings.
- Click Add Warehouse Mapping
- Select a Coalesce Warehouse from the dropdown (or enter the warehouse ID manually if not listed)
- Select the corresponding Data Warehouse integration
- The Mapping Name is auto-generated based on your selections, but you can customize it
What data is synced?
Catalog entities (Catalog → quality)
The platform pulls catalog entities and maps them to corresponding quality assets:- Tables and views
- Dashboards and reports
- Other catalog entries
Data Qualities (quality → 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 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:- Verify your API token is correct and has read permissions
- Ensure the region matches your Coalesce Catalog workspace
- Check that warehouses are configured in your Coalesce Catalog
- You can manually enter the warehouse UUID if the dropdown doesn’t populate