, the Secure Agent converts the expression in the transformation by determining equivalent operators in the database. If there is no equivalent operator, the Secure Agent processes the transformation logic.
The following table lists the
SQL ELT optimization
operators that you can push to the Google BigQuery database by using full
SQL ELT optimization
:
Operator
Operator
+
=
-
>=
*
<=
/
!=
%
AND
||
OR
>
NOT
<
Rules and guidelines
When the argument in the NOT operator is a null value, the mapping runs with source