Querying Data in a Serverless SQL Pool in Azure Synapse

Hi all,

I successfully connected from KNIME 4.4.2 to serverless SQL pool in Azure Synapse. When trying to query data with the DB Query Reader node, however, I get the error message that the T-SQL function @@TRANCOUNT is not found.

And indeed the T-SQL reference says that this function is not supported by serverless SQL pool in Azure Synapse.

Is there any workaround or solution for this issue?

Many thanks for your help,

Jan