Forum Discussion

dbeavon3's avatar
dbeavon3
Icon for Memorable Member rankMemorable Member
22 days ago
Solved

Mirrored Metadata Catalog for Databricks - No Data Agent?

Has anyone tested Data Agents in Fabric (NL2SQL)?  I'm connecting to a mirrored lakehouse that uses shortcuts to reach data in ADLS.  The Data agents rely on the SQL endpoint, and related lakehouse t...
lakehouse
  • dbeavon3's avatar
    dbeavon3
    22 days ago

    Thanks a lot for the reply.
    1. Yes, the sql endpoint works fine (eg. via SSMS)
    2. Yes shortcuts work.  But remember that mirrored unity catalog metadata is also using shortcuts under the hood.
    3. Yes select works.
    4. This is exactly what I'm hoping to avoid.  The benefit of using mirrored UC metadata is that it will keep the entire table intact, and will keep syncing metadata as it is changed over time.

    FYI, The blog link I shared is explicitly saying that UC metadata catalogs are a supported scenario



    ... I have opened a ticket today, and the engineer confirmed that this should work.  He is speaking to PG and they say there may be a regression.  Our workloads run in the NCUS region and we often see bugs that other regions don't encounter.  

    Hopefully they will fix this soon.  I don't have an ETA for a fix yet. Have a nice weekend.

dbeavon3's avatar
dbeavon3
Icon for Memorable Member rankMemorable Member
22 days ago

Thanks a lot for the reply.
1. Yes, the sql endpoint works fine (eg. via SSMS)
2. Yes shortcuts work.  But remember that mirrored unity catalog metadata is also using shortcuts under the hood.
3. Yes select works.
4. This is exactly what I'm hoping to avoid.  The benefit of using mirrored UC metadata is that it will keep the entire table intact, and will keep syncing metadata as it is changed over time.

FYI, The blog link I shared is explicitly saying that UC metadata catalogs are a supported scenario



... I have opened a ticket today, and the engineer confirmed that this should work.  He is speaking to PG and they say there may be a regression.  Our workloads run in the NCUS region and we often see bugs that other regions don't encounter.  

Hopefully they will fix this soon.  I don't have an ETA for a fix yet. Have a nice weekend.

v-abhinavmu's avatar
v-abhinavmu
Icon for Community Support rankCommunity Support
19 days ago

Hi dbeavon3​,

Thanks for the update and for sharing the details from your Support investigation.

Since Microsoft Support has confirmed that this scenario should work and is investigating the issue with the Product Group, working with Support would be the best next step.

If the issue is resolved, please consider updating this thread as well. It would be helpful for others facing a similar issue.

Thanks again for keeping the community updated.