Using Azure Data Studio

[BiJoe]

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?

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.

[AndyDDC]

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

[BiJoe]

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

[AndyDDC · Accepted solution]

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/

[v-cboorla-msft]

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.

[BiJoe]

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