Microsoft Azure Synapse SQL Connector

Back Next

SQL transformation

You can configure an SQL transformation to process SQL queries in a Microsoft Azure Synapse SQL mapping enabled for

SQL ELT optimization

Use functions to run queries

You can include functions in an entered query in an SQL transformation and run queries with the Microsoft Synapse SQL target endpoint. You must use only the SELECT clause SQL statement to push a function. Specify the column name in the select query or function.

Do not use FROM or WHERE clause in the SQL statement. For example, do not push functions using statements like "SELECT * FROM TABLE".

You can use the following functions in an entered query:

CURRENT_USER

HAS_DBACCESS

RAND

SESSION_USER

SIGN

SUSER_NAME

SUSER_SNAME

SYSTEM_USER

USER

USER_NAME

For more information about the supported functions, see the Microsoft Azure Synapse SQL documentation.

User defined functions

You can configure a custom query in an SQL transformation to read from SQL user-defined functions (UDF) in Microsoft Azure Synapse SQL. You cannot read UDFs that have newline characters in the UDF name.

Rules and guidelines

When you configure an SQL transformation, consider the following rules and guidelines:

You cannot use an unconnected SQL transformation.

You can use queries that are static. Dynamic queries are not applicable.

You cannot use functions that return multiple rows.

You cannot use the Track the number of rows affected by this query
option for the output fields.

If the mapping fails, the SQL error is not logged.

You cannot use the Max output row count
and Continue on SQL Error within row
options in the advanced properties.

Rename Saved Search

Table of Contents

Microsoft Azure Synapse SQL Connector

Microsoft Azure Synapse SQL Connector

SQL transformation

SQL transformation

Use functions to run queries

User defined functions

Rules and guidelines