Visual Studio - Build Error - Azure SQL Data Warehouse using 'SET RESULT_SET_CACHING ON/OFF'

Question

We are attempting to use 'Build Solution' within a Visual Studio project for Azure SQL Data Warehouse. There are a number of Stored Procedures in the project that use the line 'SET RESULT_SET_CACHING OFF' (or on). This is valid Syntax in Azure SQL Data Warehouse (although not in SQL Server), the Stored Procedures currently exist on the Database and execute just fine.

When we try to build / publish, we get the error: SQL46010: Incorrect syntax near RESULT_SET_CACHING

In the Project Properties, the Target Platform is set as Azure SQL Data Warehouse. We've tried in both VS 2019 and 2022.

Is this just a bug / not implemented yet? and are there any potential workarounds?

Example:

CREATE PROC [dbo].[New_Procedure] AS
BEGIN
SET RESULT_SET_CACHING OFF;
SELECT
GETDATE()
END

The above is perfectly valid in Azure Data Warehouse

Answer 1

Hi any news regarding this issue? Did you manage to solve it? It still persist.