All templates

Automated Dremio Query Performance Report

Every Monday, WebRun opens Dremio, reads last week's slowest queries, reflection refresh times, and overall query volume, checks Google Calendar for the standing data platform review, and sends the team a scorecard over WhatsApp ahead of the meeting.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:00 AM WebRunorchestrates each step
1 Dremio read query performance
2 Google Calendar check the review meeting
3 WhatsApp send the scorecard
In short

How do I get a weekly Dremio query performance scorecard?

WebRun reads your Dremio slowest queries, reflection refresh times, and query volume every Monday, checks the standing data platform review on Google Calendar, and sends the team a scorecard over WhatsApp before the meeting starts. Data platform teams walk into the review already knowing which queries need attention.

  • The team sees slow queries before the meeting starts, not during it
  • A reflection missing its refresh window gets flagged clearly
  • The weekly review opens with performance numbers already agreed on

Built for data platform teams · data engineering teams · analytics engineering teams

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens dremio.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    Dremio - read query performance
    dremio.com
    WebRun in Dremio: read query performance
    WebRun opens Dremio to read query performance.
    • Open Dremio and check last week's query history
    • Read the slowest queries and reflection refresh times
    • Compare query volume against the week before

    Done when Last week's query performance is read and compared.

  3. 2
    Google Calendar - check the review meeting
    calendar.google.com
    WebRun in Google Calendar: check the review meeting
    WebRun opens Google Calendar to check the review meeting.
    • Open Google Calendar and find the standing data platform review
    • Confirm the meeting time for this week
    • Time the scorecard send to land at least an hour before it

    Done when The scorecard is timed to arrive before this week's review.

  4. 3
    WhatsApp - send the scorecard
    whatsapp.com
    WebRun in WhatsApp: send the scorecard
    WebRun opens WhatsApp to send the scorecard.
    • Message the data platform team on WhatsApp
    • Send the slowest queries and reflection performance with the change from last week
    • Flag it clearly if a reflection is consistently missing its refresh window

    Done when The team has the scorecard on WhatsApp before the meeting.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
dremio.com
ScheduleRuns automatically on this cadence
Every Monday at 8:00 AM
DeliveryHow each run's result reaches you
Query scorecard · WhatsApp
OutputWhat each run produces - A weekly query performance scorecard with the slowest queries and reflection refresh times.
Report
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Does WebRun tune a slow query or rebuild a reflection?

No. It only reads performance data from Dremio. Tuning a query or rebuilding a reflection stays a data engineer's decision.

What counts as a reflection missing its window?

A reflection that failed to refresh within its expected schedule more than once in the week, not a single one off delay.

Does it always land before the meeting?

Yes. It checks the standing review time on Google Calendar and times the WhatsApp send to arrive at least an hour ahead.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.