Lineage Troubleshooting

Why can't I see lineage for my asset in Catalog?

I can't see the Source Query of my asset nor upstream lineage.

We compute lineage based on the last 30 days, has the asset been refreshed on this time period?

I can see the Source Query of my asset but no upstream lineage.

Are both parent and children in Catalog ? Is the source of the Table in Catalog?

We compute lineage between assets that are available in Catalog. Does Catalog has sufficient rights to extract missing metadata?

Are you using multiple layers of Temporary Tables to create your asset?

We support by default 2 levels of Temporary Tables, if you use more, reach out to your Catalog point of contact and we'll increase the setting.

I can see the Source Query of my asset, but it is truncated.

Catalog supports the full visualization of queries that have up to 100.000 characters. When a query passes this limit, it is displayed with the following mention << TRUNCATED >> and only Table level upstream lineage is calculated.

I see the Source Query of a Temporary Table for one of my materialized table.

To match a Source Query with its table associated table, we use the path of the asset. If you have a Temporary Table with the exact same name and path as a materialized one, there will be a conflict.

We suggest renaming the Temporary Table to a unique name.


Looker Specific

I can't see lineage at all for my Looker assets

We compute lineage by analysing your LookML. Have you provided access to your LookML repo to Catalog? More information here

Some of my Looker assets don't have lineage

We consistently improve our lineage engine with new scenarios. Here is a non exhaustive list we are currently not covering (coming soon):

  • {view_name.SQL_TABLE_NAME} pattern

  • Hidden fields used in calculated fields

  • Conditional lineage: Liquid

  • Native derived table

  • Refined explores


Still facing lineage issues?

Don't hesitate to reach out to your Catalog point of contact with your case, we will be happy to help investigate the missing links

Last updated

Was this helpful?