1523012 - Broken Dashboard for Focus GV

Status: RESOLVED WONTFIX

(Data Platform and Tools :: General, enhancement)

Description

[:sdaswani]

Brief Description of the request:
any reason this graph isn't updating? https://sql.telemetry.mozilla.org/queries/60292#155743

Any timelines for the request or how this fits into roadmaps:

Links to any assets (e.g Start of a PHD, BRD; any document that helps describe the project):

Name of Data Scientist (If Applicable): Megan

Comment 1

[Jess Mokrzecki [:jmok]]

Moving this out of Data Science, it looks like the tool may be broken.

Comment 2

[Mark Reid [:mreid]]

I just tried to manually refresh the query and received an error:

Error running query: Query timeout

Comment 3

[Mark Reid [:mreid]]

Jason, do you know what the timeout for Athena is?

Comment 4

[Jason Thomas [:jason]]

(Run time: 30 minutes 18 seconds, Data scanned: 149.63 GB) - before a query timeout error occurs so assuming 30 minutes. I've gone ahead and requested a DML Query limit increase to 60 minutes.

Comment 5

[Jason Thomas [:jason]]

AWS raised the limit today. I am re-running the query now to see if that helps.

Comment 6

[Mark Reid [:mreid]]

Looks like it still times out after 60 mins.

Comment 7

[Frank Bertsch [:frank]]

Megan, do we still need to work on this? If so the query is going to need some retooling.

Comment 8

[Frank Bertsch [:frank]]

Closing this in favor of the Analysis that Megan is doing for WV vs. GV.