Closed Bug 1673979 Opened 4 years ago Closed 4 years ago

Recommend DE things for search dashboard

Categories

(Data Platform and Tools :: General, task)

task

Tracking

(Not tracked)

RESOLVED FIXED

People

(Reporter: xluo, Assigned: bugzilla)

Details

(Whiteboard: searchRotation)

Attachments

(3 files)

Need DE Recommendation on how to fuel up the backend table for the search report dashboard.

  1. Create a table?
  2. Create a view?
  3. Use customized queries?

No action now, wait until we collect the first round of feedback :)

Whiteboard: searchRotation

Okay, we've scheduled the queries, fixed some of the issues we found and ran a backfill so these tables are good to go!

For posterity, looking at how much these queries cost to run, I decided to punt on doing any more complex analysis given it would take a very very long time to net out any significant time I spent investigating any optimizations especially in light of the probable migration of this dashboard to a new BI tool next year, which will have different affordances for data modeling.

Status: NEW → RESOLVED
Closed: 4 years ago
Resolution: --- → FIXED
Component: Datasets: Search → Datasets: General
Component: Datasets: General → General
You need to log in before you can comment on or make changes to this bug.

Attachment

General

Created:
Updated:
Size: