Question

Cascading Persistent Derived Tables

  • 15 March 2017
  • 2 replies
  • 111 views

I noticed something new when trying to use Cascading Persistent Derived tables…



There’s a new little “i” by the row number in the editor indicating some information on the code. When highlighted it says that the field defined by the referenced tablename ${xxx.SQL_TABLE_NAME} will only be valid if it’s joined to that table in an explore.


Curious if this is a recent change as we use cascading PDTs to build roll-ups from order to subscription to customer and have some explores where they aren’t joined.


Thoughts on how to approach?


2 replies

Userlevel 6
Badge

We are displaying a generic message for a fully scoped variable. We should probably make the message here more specific to derived tables or remove the ‘i’ here altogether.


In a sql block in a measure or dimension, if you fully scope (provide both the view and dimension or measure name separated by a dot), we put the little ‘i’ there and warn you that this code will only work if the joins are formulated correctly.


Thanks for noting this.

Userlevel 5
Badge

Just an update @DanLeBlanc - as of Looker 4.10 we won’t be showing a warning here anymore. Thanks for bringing this to our attention!

Reply