Write and review SQL for reports and metrics in a data warehouse, a store of analytical data. Applies rules for explicit columns, date filters, aggregate names, and limited exploratory results, returning SQL with a brief explanation.
Conventions and review steps for writing analytics SQL against the warehouse. Use whenever the task involves querying tables, building a report, or aggregating metrics.
Review the instructions the agent will receive before you install.
Apply this skill before writing or running any analytics SQL so reports stay consistent and safe.
Use this skill when the task involves:
SELECT explicit column names, never SELECT *.order_count, not count(*)).LIMIT unless an aggregate already collapses
the result set.COUNT(DISTINCT ...) over a sub-query when de-duplicating.SELECT *.Return the final SQL in a fenced ```sql block, then one sentence describing what the query returns.
No reviews yet. Tell others what you thought.
No login needed. Share how it worked for you, ask a question, or note where it did not run.
No comments yet. Be the first to write one.
Assess Airflow Improvement Proposals by comparing Confluence specifications with pull requests, commits, and codebase files. Produce evidence-backed progress reports showing delivered items, remaining work, and specification updates needed across one or more proposals.
Turn Airflow Improvement Proposals into practical guides checked against current code, or proposed user stories for design review before implementation. Organize use cases, distinguish verified examples from speculative code, and capture specific design questions.
Helps contributors develop and fix Airflow’s Java SDK for JVM tasks. Explains public API boundaries, JAR packaging, Python coordination, communication schema updates, and the test commands used to validate changes.
Guides contributors through adding a new programming language to Airflow, covering SDK structure, runtime coordination, communication rules, executable packaging, tests, and the documentation and configuration changes needed for a pull request.
Draft commit messages, pull request titles and descriptions, and GitHub comments or reviews for Apache Airflow contributions. Follows project wording and AI attribution rules, and helps decide whether a change needs a release note.
Guides preparation and authorized publication of Apache Airflow changes, including existing pull request checks, remote verification, reviews, tests, rebasing, and a prefilled submission page. Also explains how to track work deferred by temporary fixes.