[CDR][Findings page] Replace latest findings data view with global data view

[JordanSh]

Summary

Currently, our findings page pulls data exclusively from the latest findings DataView. With the introduction of third-party (3P) integrations, starting with Wiz, we need to replace our data view query to include a generic index pattern that fetches data from all 3P integrations, specifically logs-*_latest_misconfigurations_cdr*.

Please refer to the detailed guide in the RFC Combining 3rd party data with native Cloud Security Posture data for comprehensive instructions.

Definition of Done

• [ ] Deprecate integration's data view
• [ ] Update the findings data grid to use the new data view from https://github.com/elastic/kibana/issues/187433. Note: Use the data view accordingly to the space.
• [ ] Update findings APIs to include findings from Wiz alongside current latest findings.
• [ ] Ensure findings page supports a source filter parameter and retrieves data based on the passed value (should be support out of the box)
• [ ] Verify the score task continues to calculate only the native integration score.
• [ ] Implement necessary tests to validate the new functionality
• [ ] Today there are two data view per data stream, it seems we can remove all, otherwise document the data views that remained in the integration repo and the reason for it.

Out of Scope

• https://github.com/elastic/security-team/issues/9936

Related Links

• https://github.com/elastic/kibana/issues/187433
• https://github.com/elastic/security-team/issues/9666
• 🎬 Epic
• 🎨 Figma Designs
• 📘 RFC Document
• 🙋 Epic Review Q&A

[elasticmachine]

Pinging @elastic/kibana-cloud-security-posture (Team:Cloud Security)

[JordanSh]

moving to blocked for now, no point to start working on data pulling until Investigate options to query findings to combine native and 3rd party data is done