UiPath Documentation
activities
latest
false
Integration Service activities

Get SQL Statement Result

Get SQL Statement Result activity in the Databricks connector.

Project compatibility​

Windows | Cross-platform

Overview​

DescriptionAPI MethodAPI Path
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.GET/statements/{statement_id}

Input​

ParameterDescriptionData Type
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.

Output​

ParameterDescriptionData Type
SQL StatementThe SQL statement to execute.string
Warehouse IDID of the SQL warehouse to run the statement on.string
CatalogCatalog used as the default for the statement.string
SchemaSchema used as the default for the statement.string
Wait TimeoutHow long to wait synchronously, 0s or 5s-50s.string
On Wait TimeoutCONTINUE returns a statement_id to poll; CANCEL aborts the statement. Allowed values: CONTINUE, CANCEL.string
Row LimitMaximum number of rows to return.integer
Byte LimitMaximum result size in bytes.integer
DispositionINLINE returns data in the response; EXTERNAL_LINKS returns presigned URLs. Allowed values: INLINE, EXTERNAL_LINKS.string
FormatResult serialization format. Allowed values: JSON_ARRAY, ARROW_STREAM, CSV.string
ParametersNamed parameter markers, for example [{"name":"p","value":"1","type":"INT"}].array
Statement IDServer-assigned statement id; poll with Get Statement.string
StatusExecution state: PENDING, RUNNING, SUCCEEDED, FAILED, CANCELED, CLOSED.object
ManifestResult schema, chunk layout and row counts.object
ResultResult payload; row data is under result.data_array.object
Note:

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.

  • Project compatibility​
  • Overview​
  • Input​
  • Output​

Was this page helpful?

Connect

Need help? Support

Want to learn? UiPath Academy

Have questions? UiPath Forum

Stay updated