Synapse Serverless Pool Missing Programmability folder and objects

[jasonhorner]

Type: Bug

when navigating to the objects under a synapse serverless pool the folder for Programability is missing. This folder should contain the functions and stored procedures in the serverless pool

Azure Data Studio version: azuredatastudio 1.47.0 (c7c2b2f21505562d21972d4c135119d00806db4f, 2023-11-07T17:17:45.669Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled Modes:

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-1065G7 CPU @ 1.30GHz (8 x 1498)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled
Load (avg)	undefined
Memory (System)	31.60GB (15.50GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions (17)

Extension	Author (truncated)	Version
ssmskeymap	kev	1.1.0
agent	Mic	0.49.0
azcli	Mic	1.8.0
azuremonitor	Mic	0.1.9
cms	Mic	0.9.3
dacpac	Mic	1.14.0
kusto	Mic	0.5.8
powershell	ms-	2022.7.2
profiler	Mic	0.14.0
schema-compare	Mic	1.21.0
sql-database-projects	Mic	1.4.1
sql-dw	Mic	0.0.1
whoisactive	Mic	0.1.5
dotnet-interactive-vscode	ms-	1.0.3255010
jupyter	ms-	2021.8.1046824664
sql-prompt	Red	0.2.12
sql-search	Red	0.4.0

[cheenamalhotra]

@jasonhorner

I see them just fine.. 🤔 Tested in both Server and Azure tree views..

[jasonhorner]

@cheenamalhotra thanks for the quick response. This is for the Synapse Serverless Pool it looks like you are using a Dedicated pool from the screenshot above. Here is what I see from my end:

it should be noted I had to manually register the serverless pool db because it isn't enumerated in the Connections - >Azure per this semi-related request: https://github.com/microsoft/azuredatastudio/issues/24330

As a small piece of additional feedback it would be great to have a different icon for the different types of sql servers. for example Serverless pool, Dedicated pool, Azure SQLD B etc.

The Connections -> Azure browsing seems to do this:

but it doesn't happen in Connections - > Servers tab:

I can open this as a new feature request if that is helpful but it's probably more important to get the object browsing functionally fully working. thanks again.

[cheenamalhotra]

Thanks for the details, I can reproduce it now. Will investigate and get back on this.

[KRallanwang]

Hello, I have found the same issue, ie., in Synapse Studio, when conncted to a Serverless SQL pool, the "Programmability" folder is not available.

Have you addressed it yet?

[SanderDoD]

Is there any update when this will be updated? It is a major drawback for us potentially having to migrate away from Azure Data Studio.

[kristofegedy]

I have the same issue, and I agree this is a major problem for anyone who works with Synapse and has no alternatives but to use Azure Data Studio (using Mac or Linux). Please let us know if there is any plan to fix this

[JohnE4U]

This issue also affects Fabric data warehouse. Is there any update?