azurebackuprestoreazure-data-explorerdisaster-recovery

Azure Data Explorer: How to backup data from table with stream ingestion


We are ingesting data to an ADX Table using stream ingestion from an event hub source.

In order to plan for backup / disaster recoverability, the documentation suggests to configure continous export to recover from local outages and provide a possibility to restore data to another cluster.

Reading through the documentation of continous data export i saw in the section "limitations" that continous export is not supported for tables configured for stream ingestion.

Now i'm a bit stuck. What is the recommended way to backup those tables?


Solution

  • The support for continuous export defined on streaming ingestion tables is still being worked on, it should complete within 2021.

    However, please note that for disaster recovery scenarios, this is the highest effort, lowest resiliency, and longest time to recover (RPO and RTO), so while it provides the lowest cost you should be careful picking this option for DR.