Bigquery Scheduled Query - Auto-activating skill for GCP Skills. Triggers on: bigquery scheduled query, bigquery scheduled query Part of the GCP Skills skill category.
41
11%
Does it follow best practices?
Impact
97%
1.03xAverage score across 3 eval scenarios
Passed
No known issues
Optimize this skill with Tessl
npx tessl skill review --optimize ./planned-skills/generated/14-gcp-skills/bigquery-scheduled-query/SKILL.mdgcloud-based GCP environment setup
gcloud for project config
100%
100%
gcloud for API enablement
100%
100%
gcloud commands used
100%
100%
No bq CLI in setup
100%
50%
Parameterized variables
100%
100%
Schedule at 06:00 UTC
100%
37%
Target table specified
100%
100%
SQL aggregates by region and category
100%
100%
SQL uses prior day filter
100%
100%
Step-by-step comments
100%
100%
Error handling in scripts
100%
100%
Service account and IAM provisioning via gcloud
gcloud SA creation
100%
100%
gcloud IAM binding
100%
100%
gcloud key creation
100%
100%
BigQuery-specific roles
100%
100%
No overly broad roles
100%
100%
Parameterized project variable
100%
100%
Step-by-step comments
100%
100%
Error handling
100%
100%
roles.md justifications
100%
100%
gcloud-only IAM commands
100%
100%
Production-ready scheduled query automation
gcloud for listing queries
0%
100%
Multi-project handling
100%
100%
Disabled query check
100%
100%
Missing owner check
100%
100%
Non-zero exit on issues
100%
100%
Step-by-step structure
100%
100%
Validation comments
100%
100%
Error handling directive
100%
100%
gcloud project config
37%
100%
Report has structured format
100%
100%
Report shows both states
100%
100%
0c08951
Table of Contents
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.