Execute SQL Node

E

Data/Databricks

Execute SQL

Execute a SQL statement on a Databricks SQL warehouse. Supports SELECT, INSERT, UPDATE, DELETE, and DDL statements.

data_databricks_execute_sqldata

Inputs8

Outputs6

Security exposure3/10

Packagedata

Ratings

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

SecurityAttack surface and exposure impact.

3/10High

PrivacyPotential sensitivity of processed data.

5/10Medium

PerformanceRuntime or resource pressure.

3/10High

GovernancePolicy, audit, or compliance impact.

4/10Medium

ReliabilityOperational stability considerations.

2/10High

CostExternal or compute cost impact.

4/10Medium

Input Pins

8

Input

Execution

exec_in

Trigger

Provider

Struct

provider

Databricks provider

SchemaDatabricksProviderDatabricksProviderDatabricksProvider3 fields

provider_idstringrequired

access_tokenstringrequired

workspace_urlstringrequired

Schema enforced

Warehouse ID

String

warehouse_id

The SQL warehouse ID to execute the statement on

SQL Statement

String

statement

The SQL statement to execute

Catalog

String

catalog

Optional: The catalog to use (Unity Catalog)

Schema

String

schema

Optional: The schema to use

Row Limit

Integer

row_limit

Maximum number of rows to return (default: 10000)

Default 10000

Wait Timeout

String

wait_timeout

Timeout in seconds for synchronous execution (default: 50s, max: 50s)

Default 50s

Output Pins

6

Success

Execution

exec_out

Triggered on success

Error

Execution

error

Triggered on error

Result

Struct

result

SQL execution result

SchemaDatabricksSqlResultDatabricksSqlResultDatabricksSqlResult6 fields

statement_idstringrequired

statusstringrequired

columnsArray<DatabricksSqlColumn>required

itemsDatabricksSqlColumnarray item

namestringrequired

type_namestringrequired

type_textstringrequired

positioninteger:int64required

format int64

dataArray<Array<value>>required

itemsArray<value>array item

row_countinteger:int64required

format int64

truncatedbooleanrequired

Schema enforced

Rows

Struct Array

rows

Result rows as JSON array

Row Count

Integer

row_count

Number of rows returned

Error Message

String

error_message

Error details if the request fails

Node Info

Internal name

data_databricks_execute_sql

Category

Data/Databricks