BigQuery-specific SQL patterns: UNNEST for array expansion, STRUCT, ARRAY_AGG, DATE_DIFF/DATE_ADD, backtick-quoted table references, EXCEPT/REPLACE in SELECT, approximate aggregation, partitioned and wildcard tables.
Quellsprache: Englisch
Menü
SkillsMP hat 6 Skills aus SignalPilot-Labs/codex-signalpilot-plugin gesammelt. Öffne einen Skill, um Quelle und Details zu prüfen.
Es werden 6 von 6 gesammelten Skills angezeigt.
BigQuery-specific SQL patterns: UNNEST for array expansion, STRUCT, ARRAY_AGG, DATE_DIFF/DATE_ADD, backtick-quoted table references, EXCEPT/REPLACE in SELECT, approximate aggregation, partitioned and wildcard tables.
Quellsprache: Englisch
Populate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.
Quellsprache: Englisch
Load FIRST before any dbt project work. Covers the full 8-step dbt workflow: project scanning, skill loading, validation, macro discovery, research, technical spec, SQL writing, and verification. Also covers output shape inference, incremental model handling,…
Quellsprache: Englisch
Loaded at Step 2 for the full workflow. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.
Quellsprache: Englisch
BLOCKING REQUIREMENT: If the user's message mentions dbt, SQL, database, or data pipeline - invoke this skill as your FIRST tool call, BEFORE Read, Glob, Grep, Bash, or Agent. Covers: SignalPilot MCP tools, available skills, and the governed workflow for dbt…
Quellsprache: Englisch
Generates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts. Only load when explicitly requested.
Quellsprache: Englisch