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:
- EventHubValidationErrorFound mapping does not exist
- KQL query to extend new column with other row values
- What is considered an ingestion request in Azure Data Explorer?
- Kql function to append columns
- Kibana Query for Message that contains ":"
- Get Azure VM creation date
- How good is performance of "has" operator in Kusto when RHS is not exactly one term?
- Stuck at PIM Diagnostics via KQL
- union with all fields
- How to create an Alert for Data Collection Rule deletion across all VMs in a subscription?
- Are joins within the same cluster consistent and isolated in Azure Data Explore?
- Is it possible to change the day returned from startofweek() and endofweek()?
- How to run Get Kusto query using Rest API
- KQL: bag unpack json into single row
- ADX - KQL: Conditionally Extending Property Columns from Dynamic Column
- Where is Update Policy failure logged
- Need suggestion to implement restrictive permissions to Kusto Tables and Functions
- 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