Execute SQL statement returning data
Executes a SQL statement in Databricks and iterates over each chunk of data returned.
Example 
This flow reads customer data, transforms it, iterates over it, and inserts it into a database.
Properties
| Name | Type | Description |
|---|---|---|
| Connection | Required | Name of the Databricks connection. |
| Warehouse Id | Required | Id of the Databricks SQL Warehouse. |
| Catalog | Optional | Name of the Databricks catalog. |
| Schema | Optional | Name of the Databricks schema. |
| SQL expression and parameters | Required | Definition of the Databricks SQL command. |
| Chunk variable name | Optional | Name of the variable containing the DataReader result. |
Returns
This action iterates over all chunks of data returned for the query. You will get a IDataReader for each chunk.
Limitations
The maximum memory size of a chunk is 25 MB.