chore: make tests required for passing

[achettyiitr]

Description

• Added a separate job (all-tests-successful) to make sure that all the tests (unit, warehouse integration, integration) get successful
• It's cumbersome to mark Required for a test, especially for a Matrix when the list will be ever-growing.

Notion Ticket

https://www.notion.so/rudderstacks/Make-all-integration-tests-successful-fdb435547aa24dd9ad1109b752e1b2b4?pvs=4

Security

• The code changed/added as part of this pull request won't create any security issues with how the software is being used.

[codecov]

Codecov Report

Patch coverage has no change and project coverage change: +15.41 🎉

Comparison is base (6fd8552) 53.32% compared to head (8546f3b) 68.73%.

Additional details and impacted files

@@             Coverage Diff             @@
##           master    #3347       +/-   ##
===========================================
+ Coverage   53.32%   68.73%   +15.41%     
===========================================
  Files         329      329               
  Lines       52699    52699               
===========================================
+ Hits        28101    36224     +8123     
+ Misses      22954    14133     -8821     
- Partials     1644     2342      +698     

see 58 files with indirect coverage changes

☔ View full report in Codecov by Sentry.
📢 Do you have feedback about the report comment? Let us know in this issue.