SQL Server¶
The SQL Server worker queries a Microsoft SQL Server table and returns the results to the workflow. Use it to pull data directly from your SQL Server database without leaving the platform.
Parameters¶
Input¶
| Field | Description |
|---|---|
| Table Name | The table to query. Accepts Template Text or Upstream Data |
| Command | The SQL operation to execute. Accepts Fixed Select. Default is Select |
| Limit | Maximum number of rows to return. Accepts Fixed Number. Default is no limit |
| Columns | Columns to include in the result. Click Add Field to specify individual columns. Leave empty to return all columns |
| Where | Filter conditions for the query. Click Add Condition to add a condition or Add Condition Group to combine conditions with AND/OR logic |
Settings¶
| Field | Description |
|---|---|
| User | SQL Server username. Accepts a stored secret from the platform's credential vault |
| Password | SQL Server password. Accepts a stored secret from the platform's credential vault |
| Host | Hostname or IP address of the SQL Server instance. Accepts Template Text or Upstream Data |
| Database | Name of the SQL Server database. Accepts Template Text or Upstream Data |
Output¶
| Field | Description |
|---|---|
| Output Mode | Format of the returned data. Accepts Fixed Select. Default is Return list of lists |
| Return Mode | Whether to return all results at once or parallelize downstream execution. Accepts Fixed Select |
Result¶
Once the worker finishes successfully, it returns the query results.
- Results (list of lists)