Knowledge DropLast Tested: Mar 22, 2021 This trigger changes weekly at 6 am on Monday:MSSQL: SELECT FLOOR((DAT...
Knowledge DropLast tested: May 22, 2018 Persistent Derived Tables are automatically reaped by Looker based on ...
Knowledge DropLast tested: Jan 25, 2021 The frequency of datagroup triggers is determined by two things:1. The...
Knowledge DropLast tested: Oct 1, 2019 Yes, this will blow the cache for that datagroup regardless of the trig...
Knowledge DropLast tested: Sep 17, 2019If you schedule on the 31st, it will not run on months without 31 days....
Knowledge DropLast tested: Jul 24, 2020 A hard limit is yet to be confirmed, but we've tested as much as 365 d...
Knowledge DropLast tested: Jan 16, 2019 If a user has multiple PDTs (say for example 3 PDTs) and they want to ...
Knowledge DropLast tested: Jan 21, 2019 No, you cannot. If a derived table is persisted by datagroup_trigger, ...
Knowledge DropLast tested: Dec 1, 2020Currently no. You can, however, select from ${view.SQL_TABLE_NAME}This c...
Knowledge DropLast tested: March 21, 2021No. If we define a caching policy with a datagroup in our Explore or ...
Knowledge DropLast tested: March 2021Yes! Since datagroups use SQL triggers, you can use the exact same querie...
Knowledge DropLast Tested: Jan 21, 2019According to the datagroup docs, the cached results will be busted the ...