Follow up question for https://docs.microsoft.com/en-us/answers/questions/692580/azure-data-explorer-table-access-policies.html

Soumya Banerjee 126 Reputation points
2022-01-30T16:10:17.733+00:00

Could you also confirm if the below steps are appropriate.

If I create a follower database. Will that incur to extra cost towards data being transferred to new DB ? Also does it mean a new cluster would also be formed ( as per ARM template). Or new Follower DB can be formed in same cluster.

My plan is to :
If I create a function and a table in the existing DB to segregate and route the required data to a new table from the pipeline( coming from logstash) table, also I will alter existing function in the pipeline Table to ensure that the same data is not stored in both tables, post this , I can then deploy ARM template for Follower new DB where I can specify only this new table to be followed in new DB.

I guess then in this case Restricted view policy wont be required . I can simply give permission to the DB to the new team.

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
525 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,441 Reputation points Microsoft Employee
    2022-02-11T16:20:34.523+00:00

    Hi @Soumya Banerjee ,

    Follower cluster needs to be created in the same region as the Leader cluster. Hence, there are no "data-out" charges. Follower cluster is a different cluster with its own Compute. It is a separate resource in Azure.

    Use follower database feature to attach databases in Azure Data Explorer | Microsoft Learn

    New Follower DB cannot be created in the same cluster.

    Hope this will help. Please consider hitting accept answer. Accepted answers helps community as well.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.