To push a custom query or an SQL override to Snowflake, the task must create a temporary view based on the provided custom query and then generates the SQL ELT query with the temporary view.
Before you configure a custom query as the source object or you configure an SQL override, perform the following task:
In the SQL ELT Optimization section on the Runtime Options tab, select Create Temporary View.
Note: If you do not set the Create Temporary View property, the mapping runs without SQL ELT optimization.