skills.rest
jwmossmoz
jwmossmozCOMMUNITY
Explore all skills by this author →
GitHub

bigquery

Run ad-hoc BigQuery analyses on Mozilla telemetry data via the bq CLI.

3|Updated Jan 8, 2026
Search Tags:#queries#data-analysis#telemetry#bigquery#mozilla#dry-run#bq-cli
One-click install
npx skills add https://github.com/jwmossmoz/agent-skills --skill bigquery-jwmossmoz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery
Source: https://github.com/jwmossmoz/agent-skills/tree/main/skills/bigquery
Command: npx skills add https://github.com/jwmossmoz/agent-skills --skill bigquery-jwmossmoz

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Mozilla telemetry data is large and siloed; analysts need a reliable way to run ad-hoc queries against BigQuery to extract counts, distributions, and metrics without building dashboards.

Core Features & Use Cases

  • Ad-hoc querying of Mozilla telemetry with the bq CLI for quick insights.
  • Dry-run cost estimation and careful resource budgeting before execution.
  • Targeted table access (baseline_clients_daily, active_users_aggregates_v3, events_stream) and cross-namespace queries.

Quick Start

Run a simple query to fetch yesterday's DAU counts using the bq CLI.

Frequently Asked Questions about bigquery

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run ad-hoc BigQuery queries on Mozilla telemetry data?▼

You can run ad-hoc BigQuery queries on Mozilla telemetry using the bq CLI. This Skill executes counts, distributions, and cross-table queries across mozdata datasets. It requires proper gcloud authentication and project flags.

What is the best way to estimate BigQuery query costs before running analysis?▼

The best way to estimate query costs is by performing a dry-run. This Skill utilizes the bq CLI to execute dry-run cost estimates on Mozilla telemetry, enabling careful resource budgeting before actual data processing.

Do I need gcloud authentication to query Mozilla telemetry with bq CLI?▼

Yes, you need proper gcloud authentication to query Mozilla telemetry. Accessing mozdata or moz-fx-data-shared-prod datasets requires correct project flags and valid gcloud credentials to execute queries successfully.

Can I calculate DAU and MAU counts using BigQuery on Mozilla telemetry?▼

Yes, you can calculate DAU and MAU counts. This Skill performs ad-hoc BigQuery analysis on Mozilla telemetry data via the bq CLI, specifically supporting targeted table access like active_users_aggregates_v3 for metrics.

Why does my BigQuery telemetry query fail with legacy SQL errors?▼

Your query likely fails because it uses legacy SQL. This Skill mandates using standard SQL by always applying the --use_legacy_sql=false flag alongside appropriate project flags when querying Mozilla telemetry via bq CLI.

Related Skills

Explore More Data & Analytics Skills→
al-steval-stev

bigquery-setup

Verify gcloud CLI, ADC tokens, and BigQuery dataset connectivity.

Community
Intermediate
aech-aiaech-ai

dashboard-designer

Convert raw JSON data into reusable dashboard specifications with visualizations.

Official
Advanced
w95w95
145

statistical-analysis

Apply descriptive statistics, trend analysis, outlier detection, and hypothesis testing to datasets.

Community
Intermediate
johnkuehjohnkueh
5

bq-analytics-query

Query bq-analytics data in BigQuery using the bq CLI.

Community
Intermediate