Azure Synapse Analytics

Hiral Shah 141 Reputation points
2021-04-09T10:19:28.397+00:00

How "High availability(HA)" feature is implemented in Azure Synapse Analytics ?

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,342 questions
0 comments
Accepted answer
  1. Hiral Shah 141 Reputation points
    2021-04-11T10:22:11.437+00:00

    Hello PRADEEPCHEEKATLA-MSFT,
    Thanks for the prompt response.
    So how the snapshots are stored and retrieved. It would be really great if you can give reference to some diagram/flow chart available.
    and also could you please explain : "snapshots capture incremental changes from the data stored in your data warehouse"

    Thanks in advance.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 76,511 Reputation points Microsoft Employee
    2021-04-09T11:24:28.677+00:00

    Hello @Hiral Shah ,

    Welcome to the Microsoft Q&A platform.

    Azure Synapse Analytics uses database snapshots to provide high availability of the warehouse. A data warehouse snapshot creates a restore point that can be used to recover or copy a data warehouse to a previous state. Because Azure Synapse Analytics is a distributed system, a data warehouse snapshot consists of many files that are located in Azure Storage. Snapshots capture incremental changes from the data stored in your data warehouse.

    For more details, refer High availability for Azure Synapse Analytics.

    Hope this helps. Do let us know if you any further queries.

    ------------

    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.