search

llooker / ga_four_block_dev

MIT License
16 stars 49 forks source link

Block produces Errors, PDT build impossible #5

Open adesso-thomasrose opened 2 years ago

adesso-thomasrose commented 2 years ago

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 commented 2 years ago

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