SQL Execute

Executes a user-defined SQL clause.

Information at a Glance

Category Tools
Data source type DB
Sends output to other operators Yes
Data processing tool n/a

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.

See: Edit Table Columns Dialog Box.

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.
  • Yes - If a table with the name exists, it is dropped before storing the results.
  • No - If a table with the name exists, the results window shows an error message.

Output

Visual Output
None.
Data Output
The results of the SQL statements.