Extend view and use its dimension in a derived table sql

Looker Q&A Looker
1

Can I extend a view and use one of its dimensions in derived table sql query?

Here is an example of what I am trying to do, where timerange_start is a dimension from the extended view timerange

view: derived_table_view {
  extends: [timerange]

   derived_table: {
    sql: SELECT *
         FROM some_table
         WHERE some_table."start" = ${timerange_start}
 }
}

Currently this code results in <ERROR: column “timerange_start” does not exist >

1 Like