This post has been republished via RSS; it originally appeared at: Azure Data Explorer articles.
The data is kept by for the last 30 days.
- you require accessing earlier information about queries
- that does not conflict with any security/compliance considerations users of your cluster may have
- you can periodically export the data (using “.show queries”) and store it elsewhere (e.g. in a Kusto table in your database, using “.set-or-append” commands)
set-or-append async history with(tags='["ingest-by:myTag"]', ingestIfNotExists='["myTag"]') <| .show queries
.show operations 71af658a-c2e7-4e0a-97bc-79643b12478a