Manual Lineage Importer | Coalesce Documentation

Unfortunately, there are cases where Catalog cannot fetch the necessary metadata to automatically compute your lineage 😢

This does not mean that you can't have lineage in the app!

You just need to send a CSV file as described below 👇

The lineage will stay in Catalog until you decide to delete it. To set it up, please contact [email protected]

File expected content

Column	✅ Required	Description	Example
parent_type	✅	Type of parent asset	TABLE
parent_key	✅	Key of parent asset	my_warehouse_name.database_name.schema_name.table_name
child_type	✅	Type of child asset	TABLE
child_key	✅	Key of child asset	my_warehouse_name.database_name.schema_name.table_name

Download example CSV: manual_lineage_example.csv — 680 Bytes

Asset types

Accepted asset types are:

• TABLE

• COLUMN

• DASHBOARD

• DASHBOARD_FIELD

Accepted link types are:

• TABLE ➡️ TABLE

• TABLE ➡️ DASHBOARD

• DASHBOARD ➡️ DASHBOARD

• COLUMN ➡️ COLUMN

• COLUMN ➡️ DASHBOARD_FIELD

• COLUMN ➡️ DASHBOARD

• DASHBOARD_FIELD ➡️ DASHBOARD_FIELD

• DASHBOARD_FIELD ➡️ DASHBOARD

Asset key formats

To uniquely identify your assets, use the following conventions:

• TABLE : warehouse_name.database_name.schema_name.table_name

• COLUMN : warehouse_name.database_name.schema_name.table_name.column_name

• DASHBOARD : tool_name/folder_path/dashboard_name

• DASHBOARD_FIELD : tool_name/folder_path/dashboard_name/dashboard_field_label