When you run a mapping in advanced mode to read a Parquet file with decimal values in exponential notation and with scale more than six and write data to Microsoft Azure Synapse SQL, the mapping fails with the following error:

When the unconnected lookup contains a function in the :LKP expression, the mapping fails with an SQL compilation error. (October 2022)

When you enable the property to improve the staging performance in a mapping that reads from a Microsoft Azure Synapse SQL source, empty strings are written as null in the target. (November 2022)

When you push the IS_SPACES function from a Router or Filter transformation to process in Microsoft Azure Synapse SQL, the mapping runs without pushdown optimization. (November 2022)

When you enable the property to improve the staging performance in a mapping that reads multiple objects from a Microsoft Azure Synapse SQL source, mapping fails with the following error: