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

File expected content​

Column✅ RequiredDescriptionExample

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

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 coventions:

  • 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