elementary icon indicating copy to clipboard operation
elementary copied to clipboard

BI Lineage (Looker) not detecting usage in derived tables

Open PatFitzner opened this issue 1 year ago • 0 comments

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

PatFitzner avatar Dec 16 '24 09:12 PatFitzner