search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 908 forks source link

Stored procedures not listed on fabric data warehouse connnections #26065

Closed sufhayes closed 1 day ago

sufhayes commented 6 days ago

Type: Bug

Connect to a fabric data warehouse that has a stored procedure.

The programability folder (or stored procedures or functions) is not listed in Azure Data studio. It is listed when connecting to the same database via SSMS.

Azure Data Studio version: azuredatastudio 1.49.1 (2f696aa95a13ccabd7e0a4431d1d759e3a7b8cfd, 2024-08-13T18:12:38.831Z) OS version: Windows_NT x64 10.0.22631 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|11th Gen Intel(R) Core(TM) i5-1135G7 @ 2.40GHz (8 x 2419)| |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)|63.69GB (46.68GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (11) Extension|Author (truncated)|Version ---|---|--- copilot|Git|1.242.0 admin-pack|Mic|0.0.2 admin-tool-ext-win|Mic|0.1.3 agent|Mic|0.49.0 azcli|Mic|1.8.0 dacpac|Mic|1.14.0 import|Mic|1.6.1 profiler|Mic|0.14.0 schema-compare|Mic|1.21.0 sql-database-projects|Mic|1.4.3 sql-migration|Mic|1.5.6
cgettys-microsoft commented 1 day ago

Hi @sufhayes - thanks for the thorough bug report. This is the same issue as https://github.com/microsoft/azuredatastudio/issues/25942. It should be fixed in the November Azure Data Studio release (i.e. 1.50) release - which just came out. I personally wrote the fix and tested it before contributing it - please do let me know if it still isn't working how you'd expect :).

sufhayes commented 1 day ago

@cgettys-microsoft That's great news! Eagerly looking to test it!

sufhayes commented 1 day ago

Apparently I just updated to 1.50 and it works great!