To perform structured query language (SQL) operations in MySQL database systems—such as Amazon® Aurora®—as part of a chain, add a step that includes a MySQL connection command.
To enable these commands, an IT admin first creates a MySQL connector.
Execute Create
To execute a CREATE
statement, use an Execute Create command.
Properties
Property |
Detail |
SQL Text/File |
Enter the SQL text or file to execute. |
Outputs
Output |
Output Type |
SQL Error |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Execute Query
To execute a SELECT
query and receive its results as a comma-separated values (CSV) file, use an Execute Query command.
Properties
Property |
Detail |
SQL Text/File |
Enter the SQL text or file to execute. |
Delimiter |
Select the delimiter to use in the CSV output. |
Preview Results |
To see a preview of the returned rows, check this box. |
Outputs
Output |
Output Type |
Record Count |
Integer |
Result Set (CSV) |
File |
SQL Error |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Execute SQL
To execute any SQL command, use an Execute SQL command. If there is a result set, it 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 |
Execute Update
To execute an UPDATE
statement, use an Execute Update command.
Properties
Property |
Detail |
SQL Text/File |
Enter the SQL text or file to execute. |
Outputs
Output |
Output Type |
Record Updated |
Integer |
SQL Error |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Get Table Definition
To retrieve the details of a table—including its columns, primary keys, and foreign keys—as JSON, use a Get Table Definition command.
Properties
Property |
Detail |
Table |
Enter the table to retrieve the definition of. |
Outputs
Output |
Output Type |
Table Metadata |
File |
SQL Error |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs were given |
3 |
Error |
Failed to run the command |
Insert Records
To execute an INSERT
statement, use an Insert Records command. The source of the data can either be multi-lined text or a CSV file.
Properties
Property |
Detail |
Table |
Enter the table to insert records into. |
CSV Data Source |
Enter the CSV file to insert into the table. The columns in the CSV file must match the same order specified in Columns. |
Delimiter |
Select the delimiter used in CSV Data Source. |
Is a File |
If CSV Data Source is a file, check this box. |
Includes Headers |
If the first row of CSV Data Source is the headers, check this box. |
Columns |
Enter the list of columns that CSV Data Source will populate, in the same order as the CSV data source. |
Value Template |
Enter the custom values declaration for the INSERT command. Indicate values with a ? ; the number of ? s should match the number of fields in the target. To auto-generate, leave blank. |
Outputs
Output |
Output Type |
Record Inserted |
Integer |
SQL Error |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs |
3 |
Error |
Failed to run the command |
Upsert Records
To execute an UPSERT
statement, use an Upsert Records command. If the unique keys of an existing record match those of a record in the data source, the command updates the record; otherwise, it inserts the record.
Properties
Property |
Detail |
Target Table |
Enter the table to upsert records into. |
Staging Table (Auto-generated) |
Enter the name of the table to temporarily hold records as they upsert in the target table.
Note: Do not use an existing table; the command automatically creates and then drops this table during the upsert.
|
Unique Columns |
Enter a list of the columns that contain unique values for each record. If these columns match between records in both the staging and target tables, the command updates the record; otherwise, it inserts the record. |
CSV Data Source |
Enter the multi-lined text or CSV file to upsert into the target table. The columns in this data source must match the same order as Columns. |
Delimiter |
Select the delimiter used in CSV Data Source. |
Is a File |
If CSV Data Source is a CSV file, check this box. |
Includes Headers |
If CSV Data Source starts with a header row, check this box. |
Columns |
Enter the list of columns that CSV Data Source will populate, in the same order as the CSV data source input. |
Value Template |
Enter the custom values for the UPSERT statement. Indicate values with a ? ; the number of ? s should match the number of fields in the target. To auto-generate, leave blank. |
Outputs
Output |
Output Type |
Records Upserted |
Integer |
SQL Error |
JSON |
Exit Codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
Invalid inputs were given |
3 |
Error |
Failed to run the command |