A string containing an integer followed by a timeframe (seconds, minutes, or hours)
Definition
interval_trigger lets you trigger the regeneration of a persistent derived table based on a time interval. In the interval_trigger parameter you pass a string containing an integer followed by "seconds", "minutes", or "hours".
Example
This persistent derived table has an interval_trigger of "3 hours", so every three hours it will be triggered to rebuild:
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-14 UTC."],[],[],null,["# interval_trigger\n\n\u003cbr /\u003e\n\n\u003e This page refers to the `interval_trigger` parameter that is part of a [derived_table](/looker/docs/2512/reference/param-view-derived-table).\n\u003e\n\u003e `interval_trigger` can also be used as part of a datagroup, described on the [`datagroup`](/looker/docs/2512/reference/param-model-datagroup#interval_trigger) parameter documentation page.\n\nUsage\n-----\n\n```\nview: my_view {\n derived_table: {\n interval_trigger: \"N (seconds | minutes | hours)\"\n ...\n }\n}\n```\n\nDefinition\n----------\n\n`interval_trigger` lets you trigger the regeneration of a [persistent derived table](/looker/docs/2512/derived-tables#persistent_derived_tables_(pdts)) based on a time interval. In the `interval_trigger` parameter you pass a string containing an integer followed by \"seconds\", \"minutes\", or \"hours\".\n\nExample\n-------\n\nThis persistent derived table has an `interval_trigger` of `\"3 hours\"`, so every three hours it will be triggered to rebuild: \n\n derived_table: {\n interval_trigger: \"3 hours\"\n ...\n }\n }"]]