SQL Execute
Executes a user-defined SQL clause.
Information at a Glance
The SQL statement executed inside this operator does not have any dependency on its preceding or succeeding operator.
The connection only ensures its execution sequence within the analytic workflow.
The SQL Execute code can invoke any well-formed SQL statement, including stored procedures and in-database languages (for example, PL/R in PostgreSQL).
Input
The SQL Execute operator does not require any input, but can be connected to a data set output.
Configuration
Parameter | Description |
---|---|
Notes | Any notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk is displayed on the operator. |
Data Source | Select from the list of the data sources connected to the operator (optional).
If not specified, the SQL Execute operator gets a database connection from the preceding operator. You can select a different connection for the operator, but this selection cannot be passed to a succeeding operator. |
SQL Clause |
Click Define Clause to open the Define SQL Statement dialog box and define the SQL to run. |
Pass Output Table | Specify whether to pass the SQL Execute output to the next operator.
If Yes, the Result Table Structure details must be configured. Set this option to Yes to send the SQL Execute operator output to the next operator. If SQL Execute is a terminal operator, this setting is not required. Default value: No. |
Result Table Structure | Displays the
Edit Table Columns dialog box, where you can specify the table structure of the operator's output to pass to the next operator.
Specifying the table structure dynamically pulls the values from the alpine_sql_output variable in the SQL script. The controls that contain the values are not populated until you run the SQL script once. The button to specify the result table structure is enabled only if Pass Output File is set to Yes. |
Output Schema | The schema for the output table or view. |
Output Table | The table path and name where the results are output. By default, this is a unique table name based on your user ID, workflow ID, and operator. |
Drop If Exists | Specifies whether to overwrite an existing table. |