elementary
elementary copied to clipboard
BI Lineage (Looker) not detecting usage in derived tables
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