---
updatedAt: 2026-09-07T15:44:25.000Z
agentTools:
  projectIndex: https://docs.getmontecarlo.com/llms.txt
---

# Federated and linked connections and assets

## Overview

Many systems can read data that physically lives somewhere else. A Databricks Lakehouse Federation *foreign catalog* queries tables in a Snowflake database; a Salesforce Data Cloud *Zero Copy* object is backed by a table in your warehouse. In each case the same data is reachable from two places you've connected to Monte Carlo.

When Monte Carlo detects one of these references, it **links it back to the real source** already monitored in Monte Carlo — so you can see, from either side, that they're the same data, and so monitoring, lineage, and incidents line up instead of being split across duplicate copies.

Monte Carlo does this automatically during metadata collection:

1. **Detects** federated/foreign references on a connection.
2. **Resolves** each reference to the source connection (and, for warehouses, the source asset) already in Monte Carlo.
3. **Surfaces** the relationship in the integration settings and on the asset page (and in lineage).

<Image src="https://files.readme.io/e4591852f27789eacb33f8480049b4580a9ca0cba4dc58d8e5d0decc6182079d-Screenshot_2026-08-14_at_1.35.46_PM.png" align="center" caption="Example of foreign catalog connections in Databricks" />

## Supported integrations

| Integration                                                                           | Type      | What Monte Carlo links        |
| ------------------------------------------------------------------------------------- | --------- | ----------------------------- |
| **Databricks** (Unity Catalog foreign catalogs / Delta Shares / Lakehouse Federation) | Warehouse | Connections **and** assets    |
| **Salesforce Data Cloud** (Zero Copy)                                                 | Warehouse | Connections **and** assets    |
| **MuleSoft**                                                                          | ETL       | Connections and asset Lineage |
| **Power BI**                                                                          | BI        | Connections and asset Lineage |

> **ETL and BI connections (MuleSoft, Power BI):** Monte Carlo does **not** link individual assets through this system. Instead, the federated references these connections observe are represented as **lineage** — you'll see the relationship as edges in the lineage graph rather than as linked connections and assets in integration settings.

## How a reference resolves

Each foreign connection resolves to a source in one of three ways, shown in the **Resolved by** column:

* **Manual** — you explicitly matched it to a source (see *Manually matching* below).
* **Identifier match** — matched automatically by the connection's identity (e.g. host and database, or provider ID and share name).
* **Asset match** — matched automatically because the tables it references resolve to exactly one source in Monte Carlo.

Each reference has a status:

* **Resolved** — linked to a source in Monte Carlo.
* **Unresolved** — Monte Carlo couldn't automatically determine the source.
* **Ambiguous** — the reference matched more than one possible source.

Unresolved and ambiguous references stay listed so you can match them manually.

## Where you'll see it

**On the source or referencing integration (Settings → Integrations → *your integration*):**

* **Federation sources** — the foreign connections observed on this integration and how each resolves to a source in Monte Carlo.
* **Referenced by** — the reverse view: the connections that reference *this* integration as their source.

<Image src="https://files.readme.io/cec4a23eedc63f241065ef39f7479d06f344961f38ea411fdf74b76812300e82-Screenshot_2026-08-14_at_1.26.21_PM.png" align="center" />

**On an asset (Summary tab), for warehouse integrations that link assets:**

* **Federated source** — the native source this asset is federated from.
* **Referenced by** — the assets elsewhere that reference this asset as their source.

<Image src="https://files.readme.io/5357f8c492dee2938375235e258010dacaca1c9cd4450e7be3df872ef543220f-Screenshot_2026-08-14_at_1.27.48_PM.png" align="center" />

## Manually matching a reference

If a reference is **Unresolved** or **Ambiguous**, or you want to override an automatic match, you can set the source yourself:

1. Go to **Settings → Integrations → *your integration* → Federation sources**.
2. On the reference's row, open the actions menu and choose **Choose match** (or **Override match** for an already-resolved reference).
3. Select the source connection in Monte Carlo.

<Image src="https://files.readme.io/b20eaef6d936c7d8c562aaa9703eb59a53151382954129aae09f75a30cd13275-Screenshot_2026-08-14_at_1.40.34_PM.png" align="center" />

![](https://files.readme.io/6153eeb8c9ed52e8fc9f4f4cdc49261c1fe56794250e3ae800dc127c2374d19c-Screenshot_2026-08-14_at_1.42.46_PM.png)

The match is **sticky** — Monte Carlo keeps your chosen source on subsequent collections. On the next collection run, the connection's assets are scoped to the source you chose. To clear a manual match, choose **Remove mapping**.

**The source has to be connected to Monte Carlo first.** You can only match a reference to a connection that already exists in Monte Carlo. If the source isn't connected yet, add it from **Settings → Integrations → Add connection**.

**Creating the connection does *not* complete the match.** After the new connection finishes setting up, come back to **Federation sources**, find the reference, and match it to the connection you just created. The match is a separate, manual step.

**When do links appear?** Federated references are detected and resolved during metadata collection, so new links (and the effect of a manual match) show up on the **next collection run**, not immediately.

## Troubleshooting

* **A reference shows Unresolved:** the source may not be connected to Monte Carlo, or its identity couldn't be matched. Connect the source, or set the match manually.
* **A reference shows Ambiguous:** more than one source matched. Set the match manually to disambiguate.
* **No federated references appear at all:** confirm the source is reachable from the referencing system and that the collection credential can read its metadata. References are also only detected on the **next collection run** after the reference is created.