azure-data-explorerkqlretentionkusto-explorer
Kusto table - How to recover soft-deleted data that is retained by the Recoverability = enabled set
I have a Kusto database with the following retention policy:
{
"SoftDeletePeriod": "30.00:00:00",
"Recoverability": "Enabled"
}
Yesterday some data was removed from a table in the database since it was over 30 days old.
According to the retention policy docs, if the Recoverability attribute is set, "If set to Enabled, the data will be recoverable for 14 days after it's been soft-deleted."
My question is what is the query I execute to recover the soft-deleted data that has been lost?
I'm guessing it's something like:
.<name-of-command> table <tableName>;? Maybe there's an option somewhere to specify just how many days to recover? How do I recover soft-deleted data that is retained by the Recoverability=enabled set?
Solution
Such a recovery currently requires opening a support ticket, via the Azure portal:
- Where is Update Policy failure logged
- How to do a KQL time window join at millisecond granularity?
- Kusto Query replace the timestamp of duplicate rows
- Using Kusto scan operator to capture sequential pairs that meets criteria
- KQL Query for Calculation of ErrorDuration within Timespan
- Add text to point(s) in Kusto linechart
- Kusto query with multiple sample values from an aggregate
- How to get data for specific date (startofweek) in a given time range in KQL?
- Defining external table kind as delta
- Kusto query map through array
- java.io.UncheckedIOException: io.netty.channel.StacklessClosedChannelException while writing to adx
- KQL: Every time a word is mentioned in a column append it to a new column as a list
- KQL: Create an id column every time a value changes in column x ordered by another column y
- Display lines & values for whole range of y-axis values in Kusto linechart
- Kusto - fetch data from one table where matching records do not exist in another table
- KQL - extract property value from an array of JSON objects, based on the value of another property
- KustoIngestFactory fails to load dependent assembly at runtime with FileNotFoundException
- KQL: How to reference columns within a let query in the next query
- Create a function to calculate power of tens with a loop and reuse them in another query
- Generate Chart by Type and State
- Azure Data Explorer C# querying and ORM
- Is it possible to update rows in Azure Data Explorer (Kusto)
- Kusto query for time between records by group in one result list
- Build a tree / run recursive query in Kusto Azure Data Explorer
- Where do Kusto dashboard definitions live
- Adding fixed delay to Update Policy execution
- insert an array in column of the kql table
- Stuck at PIM Diagnostics via KQL
- Grouping on the basis of cumulative sum
- How to use table alias in KQL query