Block produces Errors, PDT build impossible

[adesso-thomasrose]

Incremental PDT Build never works:
SQL Error in incremental PDT: Failed to retrieve data - Resources exceeded during query execution: The query could not be executed in the allotted memory. Peak usage: 122% of limit. Top memory consumer(s): sort operations used for analytic OVER() clauses: 99% other/unattributed: 1%

[davidbrinegar]

Hello,

Another issue relating to scaling of the query had resolution by limiting the number of events captured per session. This refinement template (attached) adds a QUALIFY clause to the initial PDT to limit the number of captured events to <= 10,000 per session. In addition, the increment period has been reduced to 2 days instead of 3. This may help resolve the resource exceeded errors being encountered.

refinement_template.lkml.txt