StatementRequest

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "title": "StatementRequest",
  "type": "object",
  "description": "Request body for submitting a SQL statement for execution.",
  "properties": {
    "statement": {
      "type": "string",
      "description": "SQL statement or batch of SQL statements to execute. You can specify query, DML and DDL statements. The following statements are not supported: PUT, GET, USE, ALTER SESSION, BEGIN, COMMIT, ROLLBACK, statements that set session variables, and statements that create temporary tables and stages."
    },
    "timeout": {
      "type": "integer",
      "description": "Timeout in seconds for statement execution. If the execution of a statement takes longer than the specified timeout, the execution is automatically canceled. To set the timeout to the maximum value (604800 seconds), set timeout to 0."
    },
    "database": {
      "type": "string",
      "description": "Database in which the statement should be executed. The value in this field is case-sensitive."
    },
    "schema": {
      "type": "string",
      "description": "Schema in which the statement should be executed. The value in this field is case-sensitive."
    },
    "warehouse": {
      "type": "string",
      "description": "Warehouse to use when executing the statement. The value in this field is case-sensitive."
    },
    "role": {
      "type": "string",
      "description": "Role to use when executing the statement. The value in this field is case-sensitive."
    },
    "bindings": {
      "type": "object",
      "description": "Values of bind variables in the SQL statement. When executing the statement, Snowflake replaces placeholders (? and :name) in the statement with these specified values."
    }
  }
}