Define SQL Statement Dialog Box

The Define SQL Statement dialog box provides an interface to write the SQL statements for the SQL Execute operator, similar to the other Team Studio execute script operators.

To view auto-completion hints while editing the script, press CTRL+Spacebar (or CTRL+Shift+Spacebar if you are using Firefox).

The output of this operator should be assigned to a table called alpine_sql_output in the SQL script.

The following script is an example of a SQL script used in the SQL Execute operator. alpine_sql_input_1 refers to the data table fed into the SQL operator from an upstream operator, if one is present.

CREATE TABLE alpine_sql_output AS (SELECT 
"county","state","msa","pmsa","popdensity","pop","popchange","age6574","age75","crime","college",
"income","farm","democrat","republican","perot","white","black","turnout" FROM alpine_sql_input_1);