How to delete logs of metrics and checks

[dataikubest]

Is there a way to delete logs of metrics and checks?

Issue: Even if we don't use certain metric and delete it in Dataiku, the logs of that metric still exists in Dataiku instance.

[Turribeach]

Metrics can be deleted from the little cogwheel on the right hand side and selecting "Clear metrics values". Checks (or now called Data Quality rules in v12.6) can be deleted individually from the Checks (or DQ) screen.

[dataikubest]

Ah sorry I should've asked it more clearly.

Is there a way to programmatically delete metrics and checks? Instead of clicking button on icon?

[Turribeach]

If you are Externally hosting runtime databases then you can easily delete all the metrics and checks by stopping DSS and droping all the tables on the schema. When DSS restarts it will re-initialise all the tables but then all other runtime data will be purged. There isn't other programmatic way to delete metrics and checks data, you could try deleting all rows from the CHECKS* and METRICS* tables only but not sure if that will work.

If you are not externally hosting your runtime database then you should do it. 😉