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

Cannot find Stored Proc and Function folders for Fabric SQL Data warehouse in Azure Data Studio #25942

Closed viswk closed 1 day ago

viswk commented 1 month ago

Cannot find Stored Proc and Function folders for Fabric SQL Data warehouse in Azure Data Studio

ADS_TVF_

Even though SP & TVFs aren't visible but when I tried to execute the Stored Proc or TVF, able to get the result sets

ADS_TVF_1

However the same can be viewed from SSMS ( both TVFs and SP)

SSMS_TVF_

Steps to Reproduce:

  1. Connect to Fabric SQL DW Instance through SSMS or Fabric UI
  2. Create TVF or Stored Proc
  3. Once created check the TVF/SP in the SSMS (on latest version) - It would be organized in right folders
  4. Now connect to Azure Data Studio to same Fabric SQL DW instance
  5. Check the folders -- Function & Stored Proc folder doesn't exist at all

Does this issue occur when all extensions are disabled?: Yes/No

kburtram commented 1 day ago

Fixed in 1.50 release.