Execute SQL Node

E

Data/DataFusion/Tools

Execute SQL

Execute a SQL query and return results as formatted text. Ideal for agent-driven data exploration.

df_execute_sqldata

Inputs3

Outputs4

Security exposure2/10

Packagedata

Ratings

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

SecurityAttack surface and exposure impact.

2/10High

PrivacyPotential sensitivity of processed data.

0/10High

PerformanceRuntime or resource pressure.

3/10High

GovernancePolicy, audit, or compliance impact.

2/10High

ReliabilityOperational stability considerations.

2/10High

CostExternal or compute cost impact.

0/10High

Input Pins

3

Input

Execution

exec_in

Trigger execution

Session

Struct

session

DataFusion session to query

SchemaDataFusionSessionDataFusionSessionDataFusionSession1 fields

cache_keystringrequired

Query

String

query

SQL query to execute

Default SELECT * FROM data LIMIT 10

Output Pins

4

Done

Execution

exec_out

Execution completed

Result

String

result

Query results formatted as markdown table

Table

Struct

table

Query results as CSVTable for further processing

SchemaCSVTableCSVTableCSVTable4 fields

namestring | null

Optional name/identifier for this table

headersArray<string>required

itemsstringarray item

rowsArray<Array<Cell>>required

itemsArray<Cell>array item

itemsCellarray item

variant 1nullvariant

variant 2booleanvariant

variant 3integer:int64variant

format int64

variant 4number:doublevariant

format double

variant 5stringvariant

+1 more fields

sourceanyOf (2)

variant 1FlowPathvariant

pathstringrequired

store_refstringrequired

cache_store_refstring | null

variant 2nullvariant

Row Count

Integer

row_count

Number of rows returned

Node Info

Internal name

df_execute_sql

Category

Data/DataFusion/Tools