execute_sql
Run SQL queries in Databricks by specifying a statement, warehouse ID, and optional catalog or schema. Blocks execution until query completion.
Instructions
Execute a SQL statement and wait for completion (blocking)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| catalog | No | ||
| schema_name | No | ||
| statement | Yes | ||
| warehouse_id | Yes |
Input Schema (JSON Schema)
{
"properties": {
"catalog": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Catalog"
},
"schema_name": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Schema Name"
},
"statement": {
"title": "Statement",
"type": "string"
},
"warehouse_id": {
"title": "Warehouse Id",
"type": "string"
}
},
"required": [
"statement",
"warehouse_id"
],
"title": "execute_sqlArguments",
"type": "object"
}