ODBC Connector > SQL ELT optimization > SQL ELT optimization variables
  

SQL ELT optimization variables

When you use SQL ELT optimization, the Secure Agent converts the expression in the transformation by determining equivalent variables in the database. If there is no equivalent variable in the database, the Secure Agent processes the transformation logic.
The following table summarizes the SQL ELT optimization type for the available variables for supported databases:
Variables
Amazon Redshift
DB2
Google BigQuery
Microsoft Azure SQL Data Warehouse
Netezza
PostgreSQL
Snowflake
Teradata
SESSSTARTTIME()
-
-
Full
-
-
-
-
Full
SYSDATE()
-
Full
Source, Full
Source, Full
-
-
-
Full