Skip to main content

Manual Lineage Importer

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 support@coalesce.io

File Expected Content​

Column✅ RequiredDescriptionExample
parent_type✅Type of parent assetTABLE
parent_key✅Key of parent assetmy_warehouse_name.database_name.schema_name.table_name
child_type✅Type of child assetTABLE
child_key✅Key of child assetmy_warehouse_name.database_name.schema_name.table_name

CSV example

Asset Types​

Accepted assets 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, please 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