airflow-triage-assignment

Included with Lifetime

$97 forever

Check who is on Airflow triage this week, suggest the next triager, and update the rotation spreadsheet.

Data & Analyticsscripts

What this skill does

# Airflow Triage Assignment

Interactively determine who should be on Airflow triage and update the rotation
spreadsheet.

## Helper Script

`scripts/get-triage-rotation` reads the rotation spreadsheet and suggests the
next triager based on who triaged least recently.

```bash
scripts/get-triage-rotation # Show current triager + suggestion
scripts/get-triage-rotation --json # Full JSON output
scripts/get-triage-rotation --skip 1 # Skip first suggestion, show second
scripts/get-triage-rotation --skip 2 # Show third suggestion
scripts/get-triage-rotation --assign "Name" # Assign Name to next unassigned week
scripts/get-triage-rotation --assign "Name" --week 2025-04-27 # Assign to specific week
```

## Workflow

Follow this interactive workflow step by step:

### Step 1: Check current rotation

Run `scripts/get-triage-rotation --json` to get the current state.

Present to the user:
- Who is on triage **this week** (if anyone)
- The **next unassigned week** and dates
- The **suggested person** (whoever triaged longest ago)

### Step 2: Confirm or skip

Ask the user: **"Assign [suggested person] to triage for [dates]?"**

- If the user says **yes**: proceed to Step 3 with that name.
- If the user says **no** (or "next", "skip", etc.): run
`scripts/get-triage-rotation --skip N` with N incremented by 1, present the
next name, and ask again. Keep going until the user says yes.
- If the user **names someone specific**: proceed to Step 3 with that name.

### Step 3: Update the spreadsheet

Run `scripts/get-triage-rotation --assign "<name>"` to update the spreadsheet.

**Important**: The service account needs **Editor** access (not just Viewer) on the
spreadsheet for writes to work. If the update fails with a permission error, tell
the user they need to share the spreadsheet with the service accounts as an Editor.

Show the user the result and confirm the update was successful.

### Step 4: Draft Slack message

If the user asks, draft a handoff message:

```
Hey, are you good with doing Airflow triage next week (<insert date>). And are you around for taking notes during the platform infra meeting?
```

## Notes

- Members marked as "needs to shadow first" in the spreadsheet sidebar are
automatically excluded from triage suggestions. They are listed separately
in the output as needing to shadow.
- The suggestion algorithm picks whoever triaged longest ago (or never).
- The `--skip` flag is 0-indexed: `--skip 0` is the default (first suggestion),
`--skip 1` gives the second, etc.

## Authentication

The script uses GCP service account impersonation — no key files needed. It
uses your `gcloud auth` credentials to impersonate
`[email protected]` via the IAM API, then
reads/writes the spreadsheet with the service account's permissions.

The service account needs **Viewer** access for reads and **Editor** access for
`--assign`.

Files: 2

Size: 15.1 KB

Complexity: 39/100

Category: Data & Analytics

Source: https://github.com/akkomar/mozdata-claude-plugin/tree/main/skills/airflow-triage-assignment

Related in Data & Analytics

clawarr-suite

Included

Comprehensive management for self-hosted media stacks (Sonarr, Radarr, Lidarr, Readarr, Prowlarr, Bazarr, Overseerr, Plex, Tautulli, SABnzbd, Recyclarr, Unpackerr, Notifiarr, Maintainerr, Kometa, FlareSolverr). Deep library exploration, analytics, dashboard generation, content management, request handling, subtitle management, indexer control, download monitoring, quality profile sync, library cleanup automation, notification routing, collection/overlay management, and media tracker integration (Trakt, Letterboxd, Simkl).

Data & Analyticsscripts

querying-soql

Included

SOQL query generation, optimization, and analysis with 100-point scoring. Use this skill when the user needs SOQL/SOSL authoring or optimization: natural-language-to-query generation, relationship queries, aggregates, query-plan analysis, and performance or safety improvements for Salesforce queries. TRIGGER when: user writes, optimizes, or debugs SOQL/SOSL queries, touches .soql files, or asks about relationship queries, aggregates, or query performance. DO NOT TRIGGER when: bulk data operations (use handling-sf-data), Apex DML logic (use generating-apex), or report/dashboard queries.

Data & Analyticsscripts

app-store-optimization

Included

App Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.

Data & Analyticsscripts

habit-flow

Included

AI-powered atomic habit tracker with natural language logging, streak tracking, smart reminders, and coaching. Use for creating habits, logging completions naturally ("I meditated today"), viewing progress, and getting personalized coaching.

Data & Analyticsscripts

app-store-optimization

Included

Data & Analyticsscripts

visualizing-data

Included

Builds dashboards, reports, and data-driven interfaces requiring charts, graphs, or visual analytics. Provides systematic framework for selecting appropriate visualizations based on data characteristics and analytical purpose. Includes 24+ visualization types organized by purpose (trends, comparisons, distributions, relationships, flows, hierarchies, geospatial), accessibility patterns (WCAG 2.1 AA compliance), colorblind-safe palettes, and performance optimization strategies. Use when creating visualizations, choosing chart types, displaying data graphically, or designing data interfaces.

Data & Analyticsscripts