Forum Discussion

BiJoe's avatar
BiJoe
Helper II
2 years ago
Solved

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?

 

 

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.

data warehouse

5 Replies

  • AndyDDC's avatar
    AndyDDC
    Most Valuable Professional
    2 years ago

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

  • BiJoe's avatar
    BiJoe
    Helper II
    2 years ago

    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:

     

     

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee
        2 years ago

        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.