bigquery-graph

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

1|Updated Aug 30, 2026
One-click install
npx skills add https://github.com/FeexSystems/3WM-SONIK-LABS --skill bigquery-graph-feexsystems
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: bigquery-graph
Source: https://github.com/FeexSystems/3WM-SONIK-LABS/tree/main/.gemini/skills/bigquery-graph
Command: npx skills add https://github.com/FeexSystems/3WM-SONIK-LABS --skill bigquery-graph-feexsystems

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, GRAPH_EXPAND semantics, and schema design rules, which are easy to get wrong without 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 GRAPH_EXPAND, AGG() on measure columns, and measure-first aggregation strategies. - Schema DDL Advising: Helps design CREATE PROPERTY GRAPH statements with scoped properties, safe aliases, PK/FK constraints, and semantic measures. - Use Case: A data engineer needs to find shortest transfer paths between accounts in a fraud detection graph; the Skill generates a valid ANY SHORTEST GQL query with proper label usage and LIMIT safeguards. ## Quick Start Ask the assistant to write a GQL query that finds the shortest path between two accounts 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 GQL query in BigQuery?▼

Use the GRAPH clause followed by MATCH patterns with node and edge labels, then RETURN results. BigQuery supports only the GoogleSQL GQL standard, never Cypher, and path traversals should use path variables like MATCH p = (a)-[e]->(b).

How do I create a property graph in BigQuery?▼

Use CREATE PROPERTY GRAPH DDL with NODE TABLES and EDGE TABLES blocks mapping existing BigQuery tables. Define KEY columns, SOURCE KEY and DESTINATION KEY references, and scope exposed columns with PROPERTIES (col1, col2) for performance.

What is the difference between GRAPH_TABLE and GRAPH_EXPAND in BigQuery?▼

GRAPH_TABLE integrates GQL pattern matching with standard SQL for aggregations and joins. GRAPH_EXPAND flattens a semantic graph into a one-big-table view for SQL analysis, requiring AGG() on measure columns and a tree-shaped topology.

Why does my BigQuery graph query fail with GRAPH_EXPAND?▼

GRAPH_EXPAND requires a tree structure and fails on cycles, self-loops, disconnected components, or convergent diamond paths. It also fails if you select measure columns without wrapping them in AGG() or use SELECT * over graphs with measures.

Can I use Cypher queries in BigQuery property graphs?▼

No, BigQuery exclusively supports the GoogleSQL GQL standard implementing ISO GQL. Cypher syntax is not supported and must never be generated; all graph queries must use BigQuery GQL clauses like MATCH, FILTER, and RETURN.