SQL Query (Graph) Node

S

Data/Database/Graph/Query

Executes a read-only SQL query against graph overlay tables via DataFusion. Write any value that comes from outside the flow as a $placeholder and wire it into the pin that appears — never build the SQL string around it.

graph_sql_querydata

Inputs5

Outputs4

Security exposureUnrated

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

No score metadata has been set for this node yet.

Input Pins

5

Input

Execution

exec_in

Graph Connection

Struct

graph

Graph connection reference

SchemaNodeGraphConnectionNodeGraphConnectionNodeGraphConnection1 fields

cache_keystringrequired

Schema enforced

Query

String

query

SQL query string. Use $placeholders for values that come from the flow (SELECT * FROM person WHERE id = $person_id) — each one adds an input pin to wire the value into. Placeholders stand for values only; table and column names cannot be parameterized.

Params

Struct

params

Values for the query's $placeholders, as an object keyed by placeholder name without the $ (e.g. {"customer_id": 42}). Only needed when the query itself comes from a wire — a literal query derives one pin per placeholder instead. Where both supply the same name, the derived pin wins unless it is empty.

Default {}

Limit

Integer

limit

Maximum number of results

Default 1000

Output Pins

4

Done

Execution

exec_out

Query completed

Error

Execution

error

Query failed

Error Message

String

error_message

Error details

Results

Struct Array

results

Query results as JSON array

Node Info

Internal name

graph_sql_query

Category

Data/Database/Graph/Query

Version

1