Skip to content

BI Lineage (Looker) not detecting usage in derived tables #1763

@PatFitzner

Description

@PatFitzner

Describe the bug
Hello!

We have connected our instance of Elementary Cloud to Looker in order to enable Lineage to Downstream Dashboards and Tools. When a table from our DWH is referenced in a Looker view definition, the corresponding exposure is successfully generated and visible in our lineage.

view: view_name {
  sql_table_name: `project.dataset.table`
    ;;

However, when the DWH table is referenced within the definition of a derived table, no exposure is created in our lineage.

view: view_name {
  derived_table: {
    sql:
      SELECT * FROM `project.dataset.table`  ;;
  }

Environment (please complete the following information):

  • Elementary dbt package version: 0.16.1
  • dbt version you're using: cloud (versionless)
  • Data warehouse: BigQuery

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions