Azure Logic Apps On-premises data gateway doesn't allow executing native SQL queries

7
votes

I tried to execute a SQL query using Azure "On-Premises data gateway" from Azure Logic Apps. Running the logic resulted the following error message:

{ "status": 400, "message": "Gateway GetPassThroughNativeQueryMetadataAsync - this operation (Execute Native SQL) is currently not supported using an on-prem gateway connection\r\nclientRequestId: ...", "source": "sql-scus.azconn-scus.p.azurewebsites.net" }

enter image description here

There should be something wrong with my setup. If not, what's the point of having "Execute a SQL Query" if there is no support for native SQL queries? What am I doing wrong?

1
azureazure-logic-apps

1 Answers

2
votes

According to the documentation:

SQL native query is not supported for on-premises SQL server.

So this feature is not available at this point.