Write and debug BigQuery SQL with backtick identifiers, SAFE_CAST, and FORMAT_DATE.
npx skills add https://github.com/mako-ai/mako --skill dialect-bigquery
Please help me install this Agent Skill. Skill: dialect-bigquery Source: https://github.com/mako-ai/mako/tree/main/api/src/agent-skills/dialect-bigquery Command: npx skills add https://github.com/mako-ai/mako --skill dialect-bigquery
BigQuery SQL often requires precise identifiers, safe casting, and specialized functions. This dialect helps you write and debug SQL for BigQuery by guiding the correct use of backtick-quoted identifiers, casts, and BigQuery-specific functions.
Write a BigQuery SQL query that selects from a fully-qualified table like my_project.my_dataset.orders and formats order_date with FORMAT_DATE.
High-intent search queries and answers about installing and using this skill.
To write BigQuery SQL with backtick-quoted identifiers, enclose project, dataset, and table names in backticks like `project.dataset.table`. This prevents ambiguity in multi-project environments and ensures reliable query execution.
The best way to format dates in BigQuery SQL is using the FORMAT_DATE function. This specialized function allows you to parse and structure date values precisely for dashboards and data pipelines.
BigQuery SQL fails on nested or repeated fields when they are not properly flattened. You must use the UNNEST function to expand arrays and structs, allowing you to query individual records within nested fields reliably.
Yes, you can use SAFE_CAST to manage data types safely in BigQuery. It converts values to the specified type and returns NULL instead of raising an error when the cast fails, ensuring predictable data pipelines.
To use REGEXP_CONTAINS in BigQuery SQL, pass a target string and a regular expression pattern to the function. It returns a boolean indicating if the pattern exists within the string, which is ideal for filtering data.
Yes, dialect-bigquery works for building data pipelines and dashboards. It guides the correct usage of BigQuery-specific functions, safe casting, and precise date formatting required for robust, reliable analytical outputs.
gke-labsAnalyze GKE infrastructure costs from BigQuery billing export datasets.
borgheiQuery SQL databases, create visualizations, and generate insights reports.
SignalPilot-LabsProvide BigQuery SQL patterns for nested and partitioned data.
mako-aiAssist developers in writing and debugging ClickHouse SQL with dialect-aware guidance.
