Google BigQuery Connectors

Back Next

Configuring a custom query or an SQL override for the Google BigQuery source object

You can push down a custom query or an SQL override to Google BigQuery.

Before you run a task that contains a custom query as the source object or you configure an SQL override, you must set the

Create Temporary View

session property in the mapping task properties.

If you do not set the

Create Temporary View

property, the mapping runs without

SQL ELT optimization

Perform the following task to set the property:

In the mapping task, navigate to the

SQL ELT Optimization

section on the

Runtime Options

tab.

Select

Create Temporary View

Click

Finish

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.