topic Using Azure Data Studio in Data Warehouse

Using Azure Data Studio

BiJoe — Thu, 29 Feb 2024 08:03:12 GMT

I just found out I can connect to my Fabric warehouses using ADS. Opening a warehouse (properly named, not SQL endpoint), this is what I see. From the screenshot you can not see the mangled original table names, hidden due to discression. Two questions arise:

~~Is this the expected view of the warehouse tables and columns in ADS?~~
There is currently no sync of queries between Fabric and ADS?

EDIT: Never mind, a reload due to extension update solved the problem of table and column names. I think question #2 still stands regarding query, view and stored procedure sync to Fabric.

Re: Using Azure Data Studio

AndyDDC — Thu, 29 Feb 2024 09:08:59 GMT

Hi BiJoe when you say "no sync of queries between Fabric and ADS" what are you referring to? Sync of the schema?

Re: Using Azure Data Studio

BiJoe — Thu, 29 Feb 2024 09:14:57 GMT

AndyDDC sorry for lack of precision. I meant queries which can be built and run from Fabric Warehouse. Screenshot from bottom of Warehouse Explorer in browser:

Re: Using Azure Data Studio

AndyDDC — Thu, 29 Feb 2024 12:11:04 GMT

Thanks for clarifying. I don't believe there's any functionality to sync the Fabric queries to a local ADS. Database Project support is included however to source control ovjects

https://blog.fabric.microsoft.com/en-us/blog/sql-projects-support-for-warehouse-in-microsoft-fabric/

Re: Using Azure Data Studio

v-cboorla-msft — Mon, 04 Mar 2024 04:42:45 GMT

Hi BiJoe

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

Re: Using Azure Data Studio

BiJoe — Mon, 04 Mar 2024 11:55:06 GMT

Thanks, I did not know about Database Project, trying that now.