Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

60 Days of Data Days! Live and on-demand sessions, challenges, study groups and more! And it's all FREE!. Join now. Learn more

Reply
BiJoe
Helper II
Helper II

Using Azure Data Studio

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: 

 

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

 

BiJoe_0-1709193244532.png

 

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.

1 ACCEPTED SOLUTION
AndyDDC
Most Valuable Professional
Most Valuable Professional

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/

View solution in original post

5 REPLIES 5
BiJoe
Helper II
Helper II

@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:

 

BiJoe_0-1709198052389.png

 

AndyDDC
Most Valuable Professional
Most Valuable Professional

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/

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

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.

AndyDDC
Most Valuable Professional
Most Valuable Professional

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

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

June Fabric Update Carousel

Fabric Monthly Update - June 2026

Check out the June 2026 Fabric update to learn about new features.