Can you persist a derived table with a datagroup that's *not* included in the model the derived table is used in?

[LookerExperts]

Knowledge Drop

Last tested: Jan 21, 2019
 

No, you cannot. If a derived table is persisted by datagroup_trigger, that datagroup needs to be defined in every model that derived table is used in. If a datagroup isn't defined in a model that a derived table is used in, you'll get the following error:

invalid datagroup_trigger {datagroup_name} declared for {derived_table_name}

Since you cannot share identical datagroups across models, datagroups will be duplicated per explore/model if included in multiple models like this:

NOTE: even though the derived table might be used in multiple models with the same datagroup defined, the derived table build should not be triggered multiple times. Instead, it should be built once and shared across the models.

This content is subject to limited support.