Create basic Ai::TroubleshootJobEvent model

Pavel Shutsinrequested to merge
524333-create-ai-jobtroubleshootevent-model-similar-to-ai-codesuggestionevent into master

What does this MR do and why?

This MR creates basic model for storing 3 months of usage events for AI /troubleshoot command. Actual writing to DB will happen in upcoming separate MRs. The data will be used later on for backfill when ClickHouse becomes available for Dedicated instances.

Database review

Expected data volume: very small. /troubleshoot command is a small subset of regular Duo Chat interaction and all Duo Chat events considered to be small volume. Duo Chat Events records count can be found here. I expect ai_troubleshoot_job_events to be at least 10x smaller. The table is also partitioned by month with 3 months retention period only.

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #524333 (closed)

Edited by Pavel Shutsin

Merge request reports