Microsoft Azure Synapse SQL Connector

Back Next

Supported features for Microsoft Azure Synapse SQL mappings

Supported features for
Microsoft Azure Synapse SQL
mappings

When you configure

SQL ELT optimization

, the mappings support the following

Microsoft Azure Synapse SQL

properties in the Source, Lookup, and Target transformations:

If you configure properties that are not supported, the mapping runs with

SQL ELT optimization

but the properties are ignored. If the SQL ELT query generation fails, the mapping runs without

SQL ELT optimization

Source: When you configure
SQL ELT optimization
, the mappings support the following properties for a
Microsoft Azure Synapse SQL
source:
Source type - Single object, multiple objects, query, and parameter.
Parameter - Allow source object to be overridden at run time
Query options - Filter. Supports both simple and advanced filter conditions.
Schema Name Override
Table Name Override
Pre-SQL
Post-SQL
SQL Override
On Pre-Post SQL Error
Edit Metadata
Target: When you configure
SQL ELT optimization
, the mappings support the following properties for a
Microsoft Azure Synapse SQL
target:
Target type - Single object and parameter.
Target object - Existing target, Create new at runtime.
Operation - Insert, Update, Upsert, Delete, Data driven
Azure Government endpoints
Schema Name Override
Table Name Override
Truncate Table
Pre-SQL
Post-SQL
On Pre-Post SQL Error
Treat Source Rows As
Reject Threshold. Applicable only when you read from a Microsoft Azure Data Lake Storage Gen2 source.
Edit metadata when you create target at the runtime
Update override
Lookup: When you configure
SQL ELT optimization
, the mappings support the following properties for Microsoft Azure Synapse SQL connected and unconnected lookup:
Source type
Single Object - table, views, external table
Custom Query
Parameter

Multiple matches
Connected lookup - Return all rows
Unconnected lookup - Report error

Parameter - Allow source object to be overridden at run time
Schema Name Override
Table Name Override
Pre-SQL
Post-SQL
SQL Override
On Pre-Post SQL Error
Edit Metadata
Dynamic Lookup Cache for connected lookup
Output Old Value On Update for connected lookup
Insert Else Update for connected lookup
Pre-build Lookup Cache - Auto, Value