ETL+ ETL Extract SQL Statement Panel
Using SQL with ETL+. Refers to SQL statements in the ETL SQL Statement panel of ETL+ Extract, Transform and Load (ETL) window.
General Rule:
The SQL syntax used in the ETL SQL Statement panel depends on the SQL used to connect to the Source Object.
The SQL statements and syntax used in the ETL SQL Statement panel must work with the SQL syntax used to connect to the associated Source Object.
All columns must be columns from the source tables named in the FROM clause.
Source panel on the left, ETL SQL Statement panel to the right.
The SQL syntax used in the ETL SQL Statement panel is the dialect of SQL used by the Source Object. For instance, a source object that connects with MySQL will run MySQL’s dialect of SQL in the ETL SQL Statement panel.
ANSI Standard SQL
ANSI Standard SQL is (mostly) %100 Supported by ETL+ with some known exceptions.
Exceptions to ANSI Standard SQL Support:
Providex Joins See https://dataself.atlassian.net/wiki/spaces/TeckKB/pages/576094227
SQL Syntax Supported
Assign a Literal Value to a Column
SELECT
[column1],
1 AS [column2],
CONVERT(varchar(30), GETDATE() ) AS [column3]
FROM
[sourceTableName]
Assigns the value 1 to the column named “column2
" in the associated target table.
Comments
-- 1 as [someTable] comments out 1 line
/* comments out everything until closing delimiter
more comments
more comments */
Related Pages