Get SQL Statement Result

Get SQL Statement Result activity in the Databricks connector.

项目兼容性

Windows | 跨平台

概述

描述	API 方法	API 路径
Fetch the status and rows of a previously submitted Databricks SQL statement by statement_id. Poll until status.state is SUCCEEDED; other states are PENDING, RUNNING, FAILED, CANCELED and CLOSED.	获取	/statements/{statement_id}

输入

参数	描述	数据类型
Databricks SQL Statement ID *	ID of the Databricks SQL statement to fetch, as returned by Execute a SQL Query. Example: 01f188bb-89a8-116e-821e-50548abbb768.	字符串

* Required parameter.

输出

参数	描述	数据类型
SQL Statement	The SQL statement to execute.	字符串
Warehouse ID	ID of the SQL warehouse to run the statement on.	字符串
目录	Catalog used as the default for the statement.	字符串
架构	Schema used as the default for the statement.	字符串
Wait Timeout	How long to wait synchronously, 0s or 5s-50s.	字符串
On Wait Timeout	CONTINUE returns a statement_id to poll; CANCEL aborts the statement. Allowed values: CONTINUE, CANCEL.	字符串
Row Limit	Maximum number of rows to return.	整数
Byte Limit	Maximum result size in bytes.	整数
Disposition	INLINE returns data in the response; EXTERNAL_LINKS returns presigned URLs. Allowed values: INLINE, EXTERNAL_LINKS.	字符串
格式	Result serialization format. Allowed values: JSON_ARRAY, ARROW_STREAM, CSV.	字符串
参数	Named parameter markers, for example [{"name":"p","value":"1","type":"INT"}].	数组
Statement ID	Server-assigned statement id; poll with Get Statement.	字符串
状态	Execution state: PENDING, RUNNING, SUCCEEDED, FAILED, CANCELED, CLOSED.	object
Manifest	Result schema, chunk layout and row counts.	object
结果	Result payload; row data is under result.data_array.	object

备注：

You might see variations in the output depending on where you run the activity. In API workflows and Maestro Flow, a single response object containing all the fields is returned. In RPA workflows, not all fields are exposed, but you can still retrieve them from the exposed response object.