Get SQL Statement Result

Get SQL Statement Result activity in the Databricks connector.

Compatibilidad de proyectos

Windows | Multiplataforma

Información general

Descripción	método API	Ruta de la 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.	Obtener	/statements/{statement_id}

Entrada

Parámetro	Descripción	Tipo de datos
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.	String

* Required parameter.

Salida

Parámetro	Descripción	Tipo de datos
SQL Statement	The SQL statement to execute.	String
Warehouse ID	ID of the SQL warehouse to run the statement on.	String
Catálogo	Catalog used as the default for the statement.	String
Esquema	Schema used as the default for the statement.	String
Wait Timeout	How long to wait synchronously, 0s or 5s-50s.	String
On Wait Timeout	CONTINUE returns a statement_id to poll; CANCEL aborts the statement. Allowed values: CONTINUE, CANCEL.	String
Row Limit	Maximum number of rows to return.	Entero
Byte Limit	Maximum result size in bytes.	Entero
Disposition	INLINE returns data in the response; EXTERNAL_LINKS returns presigned URLs. Allowed values: INLINE, EXTERNAL_LINKS.	String
Formato	Result serialization format. Allowed values: JSON_ARRAY, ARROW_STREAM, CSV.	String
Parámetros	Named parameter markers, for example [{"name":"p","value":"1","type":"INT"}].	Matriz
Statement ID	Server-assigned statement id; poll with Get Statement.	String
Estado	Execution state: PENDING, RUNNING, SUCCEEDED, FAILED, CANCELED, CLOSED.	object
Manifest	Result schema, chunk layout and row counts.	object
Resultado	Result payload; row data is under result.data_array.	object

Nota:

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.