Azure Synapse Analytics metadata sharing

saurabh 331 Reputation points
2021-08-02T00:54:36.88+00:00

Hi,

I have below questions around metadata sharing in Azure Synapse Analytic.

a) Is it possible to share metadata between spark pool and dedicated sql pool?
b) How does different spark/sql pool resource failure scenarios will affect high availability of spark/sql pool metadata?
c) What are the suggested ways to ensure high availability and disaster recovery requirements for spark/sql pool metadata?
d) Is it possible to share metadata related to delta format files between spark/sql pool and dedicated sql pool?

Please share your thoughts and any reference material to get a better understanding of above topics.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,467 questions
{count} votes

Accepted answer
  1. Saurabh Sharma 23,761 Reputation points Microsoft Employee
    2021-08-11T19:06:54.027+00:00

    Hi @saurabh ,
    The AZ capability for Spark Databases, table definitions (plus other entities) is being already worked on it will be pushed out in all other regions probably this month end. Also, this data is already BCDR compliant.

    Thanks
    Saurabh

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful