Backward Compatibility Standalone agent integration test

[gurevichdmitry]

Summary of your changes

This PR introduces a new workflow called Test Agent Compatibility. The workflow verifies the latest Elasticsearch version against agents starting from version 8.11. It dynamically generates a matrix of jobs based on agent and package version and deploys these jobs in parallel. Each job deploys the latest Elasticsearch snapshot version, along with the defined Elastic agent, and executes sanity checks for all CSPM integrations (AWS, Azure, and GCP). The Elastic agent is deployed as a standalone agent. Please note that CSPM Azure is not tested in version 8.11 due to the lack of support for manual credentials.

Screenshot/Data

Related Issues

Checklist

• [ ] I have added tests that prove my fix is effective or that my feature works
• [ ] I have added the necessary README/documentation (if appropriate)

Introducing a new rule?

• [ ] Generate rule metadata using this script
• [ ] Add relevant unit tests
• [ ] Generate relevant rule templates using this script, and open a PR in elastic/packages/cloud_security_posture

[mergify[bot]]

This pull request does not have a backport label. Could you fix it @gurevichdmitry? 🙏 To fixup this pull request, you need to add the backport labels for the needed branches, such as:

• backport-v./d./d./d is the label to automatically backport to the 8./d branch. /d is the digit NOTE: backport-skip has been added to this pull request.

[github-actions[bot]]

:bar_chart: Allure Report - :green_heart: No failures were reported.

Result	Count
🟥 Failed	0
🟩 Passed	359
⬜ Skipped	33

[gurevichdmitry]

Successful run

[gurevichdmitry]

the latest successful run