Skip to content

Column-level lineage break when using ephemeral models (dbt-spark) #55

Description

@pedro-mellosousa

Hi there! First of all, thank you for the amazing project—it's a very helpful tool.

I am experiencing an issue where column-level lineage is lost during the transition between the layers of my ETL pipeline. I am using dbt-spark, and I've noticed that the lineage "gap" occurs specifically between two models that utilize a ephemeral model as intermediate.

Context: I have 3 models, A, B and C, A and C are tables, but B is ephemeral. This models persist the same column id, where B consume id from A, and C consume the id from B.

The issue is: The column lineage is interrupted at Model B. The UI displays the column from Model A in isolation and the column from Model C in isolation, failing to establish the connection between them. Model B does not appear in the column lineage graph at all.

Question: Is this a known limitation of the parser regarding ephemeral models within the Spark dialect, or is there a specific configuration I should adjust to ensure the lineage persists across these models?

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions