ci: implement e2e test for Sink

[nanderstabel]

I hereby agree to the terms of the Singularity Data, Inc. Contributor License Agreement.

What's changed and what's your intention?

Add sink e2e test to CI.

Checklist

~~- [ ] I have written necessary rustdoc comments~~ ~~- [ ] I have added necessary unit tests and integration tests~~

• [ ] All checks passed in ./risedev check (or alias, ./risedev c)

Refer to a related PR or issue link (optional)

[codecov[bot]]

Codecov Report

Merging #4198 (a373188) into main (f521bfc) will increase coverage by 0.06%. The diff coverage is n/a.

:exclamation: Current head a373188 differs from pull request most recent head 6d93165. Consider uploading reports for the commit 6d93165 to get more accurate results

@@            Coverage Diff             @@
##             main    #4198      +/-   ##
==========================================
+ Coverage   74.37%   74.44%   +0.06%     
==========================================
  Files         842      841       -1     
  Lines      121514   121156     -358     
==========================================
- Hits        90379    90192     -187     
+ Misses      31135    30964     -171     

Flag	Coverage Δ
rust	74.44% <0.00%> (+0.06%)	:arrow_up:

Flags with carried forward coverage won't be shown. Click here to find out more.

Impacted Files	Coverage Δ
src/frontend/src/catalog/schema_catalog.rs	79.38% <0.00%> (-2.57%)	:arrow_down:
src/meta/src/barrier/mod.rs	81.87% <0.00%> (-1.53%)	:arrow_down:
src/meta/src/hummock/metrics_utils.rs	90.32% <0.00%> (-0.59%)	:arrow_down:
src/storage/src/hummock/state_store.rs	79.71% <0.00%> (-0.58%)	:arrow_down:
src/storage/src/hummock/iterator/forward_merge.rs	96.76% <0.00%> (-0.26%)	:arrow_down:
src/meta/src/barrier/recovery.rs	61.50% <0.00%> (-0.23%)	:arrow_down:
src/storage/src/hummock/shared_buffer/mod.rs	90.60% <0.00%> (-0.19%)	:arrow_down:
...e/src/hummock/shared_buffer/shared_buffer_batch.rs	93.73% <0.00%> (-0.14%)	:arrow_down:
src/storage/src/hummock/iterator/backward_user.rs	96.67% <0.00%> (-0.12%)	:arrow_down:
...e/src/hummock/sstable/backward_sstable_iterator.rs	97.51% <0.00%> (-0.11%)	:arrow_down:
... and 26 more

:mega: Codecov can now indicate which changes are the most critical in Pull Requests. Learn more

[tabVersion]

I briefed the pr and I think this can be merged to branch ns-sink-meta instead of main