Hi, team. Is there a way to replace queries section for dataset when ingesting it? When you ingest new query, it doesn't replace existing queries, but appends to them.

Hi @miniature-journalist-76345 Currently UI shows entire set of top sql queries reported in past month. So if top queries are ingested for everyday, you'll see all the top queries from past month.

We're ingesting them every day, and if, for example, some columns get removed, queries may become invalid

Right. That would be easier.. you can do it before or after ingesting new one. or if you only need to remove sql queries only and keep other info (user count, etc), you can re-ingest the older aspect (aspect with invalid query) with exactly same timestamp and updated/empty sql queries.

Hmm, ingesting same timestamp will overwrite them?

yes

But if this timestamp is more than a month older, query will not be displayed?

yes, that's what I would expect.

Then I need a better workaround 😞