Menu
Load when writing or debugging BigQuery SQL, including project.dataset.table names, backtick identifiers, date formatting, casts, regex functions, and BigQuery-specific query limits.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Load when building, editing, or debugging Mako React apps — app files, npm dependencies, data bindings, the @mako/app-sdk hooks (useQuery / useDuckDB / useLocation / useSearchParams / navigate), URL state and shareable deep links, materialized Parquet/DuckDB bindings, and the live preview runtime.
Load for dbt branches, commits, pushes, pull requests, merges, repository sync, or branch cleanup.
Load when creating, editing, scheduling, running, or debugging dbt jobs and production deployments.
Load when building, editing, running, or debugging dbt models, dbt projects, schema.yml tests, sources, seeds, snapshots, incremental models, materializations, or dbt jobs in the Transforms section.
Load when creating, editing, configuring, validating, or debugging database sync flows, connector flows, pagination, incremental sync, destination mappings, and flow form fields.
Add a new MCP server preset (connector) to Mako's MCP client system — server URL, auth model (OAuth DCR, pre-registered app, or API key), scopes, icon, tests, and docs. Use when connecting a new external MCP server (like Slack or Close CRM) or changing how MCP connections authenticate.
| name | dialect-bigquery |
| description | Load when writing or debugging BigQuery SQL, including project.dataset.table names, backtick identifiers, date formatting, casts, regex functions, and BigQuery-specific query limits. |
| entities | ["bigquery","google bigquery","sql","dataset","project.dataset","safe_cast","regexp_contains"] |
Use this skill for Google BigQuery connections.
| Feature | BigQuery syntax | Notes |
|---|---|---|
| Identifiers | `project.dataset.table` or `column` | Fully qualify tables when project/dataset is known. |
| Type casts | CAST(x AS type), SAFE_CAST(x AS type) | Prefer SAFE_CAST for dirty data. |
| String concat | CONCAT(a, b) | ` |
| Pattern match | REGEXP_CONTAINS(value, r'pattern') | Use raw regex strings with r''. |
| Dates | DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) | Use BigQuery date/time functions. |
| Formatting | FORMAT_DATE('%Y-%m', order_date) | Use FORMAT_TIMESTAMP for timestamps. |
| Arrays/structs | UNNEST(array_col) | Use aliases when unnesting repeated fields. |
Avoid relying on PostgreSQL-specific casts (::type) or interval syntax. Be careful with subqueries and always test the BigQuery dialect returned by inspection tools.
-- project: my_proj, dataset: analytics
SELECT
product,
FORMAT_DATE('%Y-%m', order_date) AS month,
SUM(amount) AS total_sales
FROM `my_proj.analytics.orders`
WHERE order_status = 'completed'
AND order_date >= '2024-01-01' AND order_date < '2025-01-01'
GROUP BY product, month
ORDER BY product, month
LIMIT 500;
This calculates monthly sales by product using BigQuery backtick identifiers and FORMAT_DATE.