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

.