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.

Schemaobjectobjectobject0 fields

No named fields in this schema.

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

Schemaobjectobjectobject0 fields

No named fields in this schema.

Node Info

Internal name

graph_sql_query

Category

Data/Database/Graph/Query

Version

1