Query Writer FAQs

Name: Query Writer
Author: mozilla

Question 1

When should I use this skill?

Accepted Answer

You should use this skill whenever you are writing or modifying `query.sql` or `query.py` files within a BigQuery ETL environment. It is particularly useful for handling complex data patterns like incremental refreshes, CTEs, and user-level aggregations.

Question 2

How does this skill handle automated testing?

Accepted Answer

Test management is a core feature. Whenever a query is modified, the skill automatically checks for existing tests and coordinates updates to fixtures and expected outputs, ensuring that your data pipelines don't break during updates.

Question 3

Does it support Mozilla-specific tools and conventions?

Accepted Answer

Yes. It is fully integrated with Mozilla-specific tooling like `bqetl` for formatting and validation. It also references local metadata, the Glean Dictionary, and DataHub to ensure schemas and descriptions are accurate.

Question 4

What is the Query Writer Claude Code Skill?

Accepted Answer

The Query Writer is a specialized capability for Claude Code designed to build, update, and maintain BigQuery SQL and Python ETL scripts. it ensures all code follows Mozilla’s specific data engineering standards, including strict formatting and partitioning patterns.

Question 5

Can it help with BigQuery partitioning requirements?

Accepted Answer

Absolutely. The skill follows strict templates for incremental and full-refresh queries, ensuring the correct use of parameters like `@submission_date` and appropriate filtering to optimize performance and cost.

Query Writer

Query Writer

주요 기능

사용 사례

주요 기능

사용 사례