Is there a way to get DAB running on top of Synapse Serverless SQL Pool

[kg875]

Hi,
Kind of an extension of this discussion: #1363

I wanted to understand if there is any workarounds for creating a GraphQL endpoint using DAB with a Synapse SQL Serverless Pool?

I've read in previous discussions that dedicated is not supported due to fact that DAB uses FOR JSON PATH, which serverless supports.

Unfortunately, my attempts so far have resulted in an error due to NO_BROWSETABLE not being supported:

Azure.DataApiBuilder.Service.Startup[0]
      Unable to complete runtime initialization. Refer to exception for error details.
      Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: 
Cannot obtain Schema for entity Products with underlying database object source: shop.products due to: NO_BROWSETABLE is not supported for SET.

Thanks!

[seantleonard]

I opened an issue to track adding support for Synapse Serverless SQL Pool #1849

I don't have any work arounds at the moment but you are welcome to do some additional investigation to determine which schema resolving query is causing a failure in DAB due to some incompatibility:

I would suggest first setting a breakpoint and starting here:
https://github.com/Azure/data-api-builder/blob/7efa7f4823382e346205ab5e3617080ec9fb0bea/src/Core/Services/MetadataProviders/SqlMetadataProvider.cs#L1227C3-L1234C33

            string tablePrefix = GetTablePrefix(conn.Database, schemaName);
            string queryPrefix = string.IsNullOrEmpty(tablePrefix) ? string.Empty : $"{tablePrefix}.";
            selectCommand.CommandText
                = $"SELECT * FROM {queryPrefix}{SqlQueryBuilder.QuoteIdentifier(tableName)}";
            adapterForTable.SelectCommand = selectCommand;


            DataTable[] dataTable = adapterForTable.FillSchema(EntitiesDataSet, SchemaType.Source, tableName);
            return dataTable[0];

[Aniruddh25]

• @rohkhann since he was getting a similar error

[HariprasadM-TomTom]

Also getting the same error when trying to use "dab" over Synapse serverless pool. Tried with both external table and view.
info: Azure.DataApiBuilder.Core.Services.ISqlMetadataProvider[0] [Azure] REST path: /api/Azure fail: Azure.DataApiBuilder.Service.Startup[0] Unable to complete runtime initialization. Refer to exception for error details. Azure.DataApiBuilder.Service.Exceptions.DataApiBuilderException: Cannot obtain Schema for entity Azure with underlying database object source: dbo.azureinventorylive due to: NO_BROWSETABLE is not supported for SET.

[mahadevan-lakshminar]

Did this issue get any traction for enhancement?

We tried using "sqldw" as the database-type and the container booted up successfully but path "/api/temp2" gave a "503 - Service Unavailable" error.