home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Admin Settings - Datagroups

Datagroup Information

Datagroups let you specify query caching policies and triggers for rebuilding PDTs. If you have permissions to access the Datagroups page in the Database section of the Admin menu, you’ll see a summary of datagroups defined in a model for which they have data access:

The Datagroups page provides the following information for each datagroup:

Column Definition
Name The name of the datagroup, which you define in the model file.
Label Specifies an optional datagroup label, which you define for the datagroup parameter in the model file.
Connection The database connection of the datagroup.
Model The LookML model where the datagroup is defined. (Click the LookML button to open the LookML model file.)
Type The datagroup’s trigger type, such as sql_trigger. If the datagroup has no specified trigger type, Type will be blank.
Description Specifies an optional datagroup description, which you define for the datagroup parameter in the model file. The datagroup description can be used to explain the datagroup’s purpose and mechanism.
Actions Actions you can take on the datagroup (see below).

Depending on the datagroup status, the following detailed information may also be displayed under the name:

Datagroup Actions

Depending on your permissions, you can perform the following actions on datagroups from the Datagroups Admin page:

  1. Click on the LookML button to open the LookML model file where the datagroup is defined.
  2. Select Reset Cache from the gear menu to immediately invalidate the cached results for all Explores using that datagroup.
  3. Select Trigger Datagroup from the gear menu to invalidate the cached results for all Explores and rebuild all PDTs using that datagroup. The PDT rebuild will begin based on the next time specified in the connection’s PDT And Datagroup Maintenance Schedule field, such as every five minutes. Any scheduled data deliveries that use the datagroup as a trigger will be sent when the triggered datagroup reaches the ready state.
Top