question

HiralShah-8227 avatar image
0 Votes"
HiralShah-8227 asked DavidBrowne-msft commented

Azure Synapse Analytics

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

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HiralShah-8227 avatar image
0 Votes"
HiralShah-8227 answered DavidBrowne-msft commented

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered HiralShah-8227 edited

Hello @HiralShah-8227,

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·