> ## Documentation Index
> Fetch the complete documentation index at: https://docs.synq.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Coalesce Catalog

> Connect Coalesce Quality with your Catalog workspace for bidirectional metadata sync

<Note>
  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:
  <br /> → Admin access to your Coalesce Quality workspace
  <br /> → Admin access to your Coalesce Catalog workspace
  <br /> → At least one data warehouse integration configured in the platform (for warehouse mappings)

  ⏱️ Estimated time to finish: 15 minutes.
</Note>

# 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

**From quality to Catalog:**

* 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 example `Coalesce Catalog` or `Production Catalog`

## Select the region

Select your Coalesce Catalog region from the dropdown:

* **Rest of World (EU):** [https://app.castordoc.com/](https://app.castordoc.com/)
* **United States:** [https://app.us.castordoc.com/](https://app.us.castordoc.com/)

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

<Note>Coalesce Catalog API tokens are managed by your organization's Catalog ops team</Note>

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

<Warning>Store your API token securely. Coalesce Catalog tokens provide access to your workspace metadata and should be treated as sensitive credentials.</Warning>

## 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.

<Note>You must have at least one data warehouse integration (BigQuery, Snowflake, Databricks, etc.) configured before you can add warehouse mappings.</Note>

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 **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 Catalog warehouses with their corresponding data warehouse integrations.

# 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

This mapping ensures that when you view an asset in either platform, it's linked to its counterpart, providing a unified experience.

## 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-level qualities:**

* Column-specific monitor results
* Field-level test outcomes
* Column health indicators

This enables your data consumers to see quality status directly in the catalog without needing to switch platforms.

# 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 the catalog?

Data Quality entries 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.
