bigquery-view-generator

Bigquery View Generator - Auto-activating skill for GCP Skills. Triggers on: bigquery view generator, bigquery view generator Part of the GCP Skills skill category.

0.92x

Quality

11%

Does it follow best practices?

Impact

83%

0.92x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./planned-skills/generated/14-gcp-skills/bigquery-view-generator/SKILL.md

Evaluation results

100%

E-Commerce Analytics Layer: BigQuery Views

Production-ready BigQuery view generation

Criteria

Without context

With context

CREATE OR REPLACE VIEW syntax

100%

Fully-qualified view names

100%

No SELECT *

100%

Fully-qualified source tables

100%

Column aliasing

100%

Three view files present

100%

CLV view joins orders and customers

100%

Aggregation in CLV

100%

README documents all views

100%

Correct target dataset

100%

Without context: $0.1857 · 42s · 11 turns · 12 in / 2,700 out tokens

With context: $0.4124 · 1m 18s · 25 turns · 284 in / 4,937 out tokens

100%

BigQuery View Deployment: Operational Runbook

Step-by-step guidance and gcloud deployment

Criteria

Without context

With context

Uses bq CLI command

100%

gcloud/bq not Python SDK

100%

Project ID parameterized

100%

Dataset creation step

100%

Numbered steps in runbook

100%

Prerequisites section

100%

Verification step

100%

View SQL passed to bq command

100%

Runbook step count

100%

No large file downloads

100%

Without context: $0.3807 · 1m 41s · 19 turns · 20 in / 5,753 out tokens

With context: $0.3633 · 1m 18s · 21 turns · 20 in / 4,715 out tokens

50%

-20%

BigQuery View Quality Review

View validation against common standards

Criteria

Without context

With context

SELECT * removed

100%

CREATE OR REPLACE VIEW used

100%

Fully-qualified table names

Fully-qualified view names

SELECT * flagged in report

100%

Unqualified names flagged

CREATE VIEW vs CREATE OR REPLACE flagged

100%

Structured report format

100%

Both corrected files present

100%

Changes documented

100%

merchant_summary preserves aggregation

100%

Without context: $0.3061 · 1m 18s · 19 turns · 20 in / 4,427 out tokens

With context: $0.4840 · 1m 44s · 28 turns · 28 in / 6,109 out tokens

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 0c08951

Evaluated: 18 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

E-Commerce Analytics Layer: BigQuery Views BigQuery View Deployment: Operational Runbook BigQuery View Quality Review

Is this your skill?

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.