improve coverage of with_options_sink.yaml

[hzxa21]

          I just realized that with options for cassandra sink are not included in this yaml. Let's revisit other sinks as well to ensure all sinks are covered.

Originally posted by @hzxa21 in #15516 (comment)

[github-actions]

This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned.

[hzxa21]

@xxhZs Any updates?

[xxhZs]

Here it's because we only support similar logic for rust's sinks, and given that we have fewer and fewer java implementations of sinks, it's not clear if we'll still have to implement this check for java_sink

[hzxa21]

Fair enough. I will close this issue for now.