bigquery-graph

Generates GQL queries and property graph DDL for BigQuery graph analytics.

Updated Aug 26, 2026
One-click install
npx skills add https://github.com/SmileAfterBurn/pani-dumka-ai --skill bigquery-graph-smileafterburn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery-graph
Source: https://github.com/SmileAfterBurn/pani-dumka-ai/tree/main/.gemini/skills/bigquery-graph
Command: npx skills add https://github.com/SmileAfterBurn/pani-dumka-ai --skill bigquery-graph-smileafterburn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Writing correct BigQuery graph queries and property graph schemas requires deep knowledge of GQL syntax, GRAPH_TABLE integration, semantic measures, and structural limitations, which is error-prone without expert guidance. ## Core Features & Use Cases - GQL Query Generation: Produces standards-compliant BigQuery GoogleSQL GQL queries with correct pattern matching, path variables, and output formatting for visualization or tabular results. - Semantic Graph Querying: Guides use of the GRAPH_EXPAND function and AGG() for measure columns in flattened semantic graph views. - Schema DDL Advisory: Assists in writing CREATE PROPERTY GRAPH DDL with scoped properties, safe aliases, key constraints, and semantic measures. - Use Case: A data engineer needs to find the shortest transfer path between two accounts in a financial graph and visualize the network; the Skill generates a correct ANY SHORTEST GQL query with TO_JSON output and a LIMIT clause. ## Quick Start Ask the assistant to write a GQL query that finds all accounts connected by transfers within three hops in your BigQuery property graph.

Frequently Asked Questions about bigquery-graph

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write a graph query in BigQuery using GQL?▼

BigQuery graph queries use the GoogleSQL GQL standard with MATCH patterns over nodes and edges, ending with a RETURN clause. Use GRAPH_TABLE only when you need SQL aggregation or joins with relational tables; otherwise write standalone GQL statements.

How do I create a property graph in BigQuery?▼

Use the CREATE PROPERTY GRAPH DDL statement, defining NODE TABLES with keys and scoped properties, and EDGE TABLES with SOURCE KEY and DESTINATION KEY references. Always assign safe aliases with AS and limit exposed properties for better query performance.

Can I use Cypher queries in BigQuery property graphs?▼

No, BigQuery property graphs only support the BigQuery GoogleSQL GQL standard, which implements the ISO GQL standard. Cypher queries are not supported and must never be generated.

Why does my BigQuery graph measure column fail in a SELECT statement?▼

Measure columns cannot be selected directly; you must wrap them in the AGG() function when querying through GRAPH_EXPAND. Using SELECT * over a graph with measures also fails, so explicitly list non-measure columns or use EXCEPT.

What graph structures are unsupported by GRAPH_EXPAND in BigQuery?▼

GRAPH_EXPAND requires a tree structure and does not support disconnected graphs, directed cycles, self-loops, or convergent diamond paths. For such topologies, use standard GQL pattern matching or split the graph into separate queries.