To perform structured query language (SQL) operations in Workiva Carbon as part of a chain, add a step that includes a Workiva Carbon command.
To enable these commands, an IT admin first creates a Workiva Carbon connector.
Execute SQL
To execute any SQL command, use an Execute SQL command. Any result set will be available as a file output.
Properties
| Property | Detail |
|---|---|
| SQL text/file | Enter the SQL text or file to execute. |
Outputs
| Output | Output type |
|---|---|
| Record count | Integer |
| Result set (CSV) | File |
| Records updated | Integer |
| SQL error | JSON |
Exit codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | Invalid inputs |
| 3 | Error | Failed to run the command |