Microsoft Azure Synapse SQL Connector

Back Next

Configuring a custom query for the Microsoft Azure Synapse SQL source object

You can push down a custom query to Microsoft Azure Synapse SQL.

Before you run a task that contains a custom query as the source object, you can set the

Create Temporary View

property in the mapping task properties.

Perform the following task to set the property:

In the mapping task, navigate to the

SQL ELT Optimization

section on the

Runtime Options

tab.

Set the

Create Temporary View

option based on your requirement.

When the

Create Temporary View

option is disabled, the task incorporates the custom query as a sub-query in the SQL ELT query.

When the

Create Temporary View

option is enabled, the task creates a temporary view based on the provided custom query and then generates the SQL ELT query with the temporary view.

Click

Finish

Watch

Comments

0 COMMENTS

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