Drop data query validation

Hi Everybody,

can anyone help on this query , we need to know the equivalent query in nrql

nrqlDropRulesCreate(accountId: xxxxxxx, rules: [
{
action: DROP_DATA
nrql: “SELECT * FROM WHERE DataUsage > 90 GB”
description: “Drops all data for that exceeds 90 GB data usage.”
}
])
{
successes { id }
failures {
submitted { nrql }
error { reason description }
}
}
}

Hi @product3, Sorry you have been waiting awhile for a response from our community.
I’m going to bring this back to the attention of our support team. Thanks for your patience!

Neal Mc

Hi product3,

Drop Rules architecture is plugged into the ingest-data-pipeline and used to eliminate fields or rows before persistence in the telemetry database (NRDB). This architecture is not used for data retention.

Here is a doc link that discusses retention limits.