Admin settings - Datagroups

Datagroups let you specify query caching policies and triggers for rebuilding PDTs. If you have permissions to access the Datagroupspage in the Databasesection of the Admin panel, you'll see a summary of datagroups defined in a model for which they have data access .

Datagroup information

The Datagroupspage 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 LookMLbutton to open the LookML model file.)
Type	The datagroup's trigger type, such as sql_trigger or interval_trigger . If the datagroup has no specified trigger type, Typewill 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 the Datagroup actions section for more details) .

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

• Statusshows the current status of the datagroup. The status is also indicated by the colored dots next to each line for the datagroup:
• Green— The datagroup is in a ready state.
• Orange— The datagroup is in the triggered state, or the datagroup was recently deployed to production and the trigger check cycle has not yet started.
• Red— The most recent trigger check errored, or there is an error with the datagroup's LookML. You can click the LookMLbutton to open the LookML model file.
• Trigger valueshows the result of the sql_trigger query that triggered the datagroup. For example, if a datagroup uses a SQL trigger based on the maximum ETL log ID, the Trigger valuewould show the new ETL log ID that triggered the datagroup.
• Triggered sinceis displayed for datagroups in the triggered state to show how long it has been since the datagroup was triggered. This provides information on how long it is taking to rebuild PDTs and run the queries that triggered by the datagroup. Once all PDTs are rebuilt, the datagroup's color will update to green to indicate that the datagroup is ready, and after several minutes the Triggered sinceinformation will disappear from the page since the datagroup is complete.
• Trigger errorprovides error information for the datagroup triggers, such as a syntax error in the datagroup's SQL trigger. When you see an error, you can click the LookMLbutton to open the LookML model file and correct the SQL syntax.
• Trigger last checkedshows the last time that the datagroup's sql_trigger SQL query was run. If the value returned by the query is different next time, that triggers the datagroup.
• Cache reset atshows the time when the cache was last reset (when the cached data in the datagroup was last invalidated).

Datagroup actions

If you have the necessary permissions for updating datagroups , you can perform the following actions on datagroups from the DatagroupsAdmin page:

1. Click the LookMLbutton to open the LookML model file where the datagroup is defined.
2. Select Reset Cachefrom the gear menu settings to immediately invalidate the cached results for all Explores using that datagroup.
3. Select Trigger Datagroupfrom the gear menu settings 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 of Looks , dashboards , and LookML dashboards that use the datagroup as a trigger will be sent when the triggered datagroup reaches the ready state.