Skip to main content

Manual Lineage Importer

Catalog computes lineage from warehouse and BI metadata. When Catalog cannot infer a relationship, you can supply manual lineage in a CSV file. Contact support@coalesce.io to set up ingestion. Manual lineage remains in Catalog until you delete it.

If you build the file in Excel or Google Sheets, save as CSV (Comma delimited), not CSV UTF-8.

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 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​

Use the following conventions to identify assets:

  • 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