[e2e] Add env var in local e2e run to sandbox all infra (#6704)

[aHenryJard]

Proposed changes

• Add env var to sandbox infra when running tests locally.
• use same name as CI for elastic

Related issues

Checklist

• [ ] I consider the submitted work as finished
• [ ] I tested the code for its functionality
• [ ] I wrote test cases for the relevant uses case (coverage and e2e)
• [ ] I added/update the relevant documentation (either on github or on notion)
• [ ] Where necessary I refactored code to improve the overall quality

Further comments

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 67.54%. Comparing base (e383348) to head (6f95377).

Additional details and impacted files

@@            Coverage Diff             @@
##           master    #7002      +/-   ##
==========================================
- Coverage   67.54%   67.54%   -0.01%     
==========================================
  Files         561      561              
  Lines       68754    68754              
  Branches     5837     5836       -1     
==========================================
- Hits        46443    46438       -5     
- Misses      22311    22316       +5     

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.