Clean DeprecationWarning from SDK/tests #18303
Description
There are many DeprecationWarnings in the tests for different reasons. These need to be cleaned otherwise we may end up in a broken state as python/dependencies change.
Imported from Jira BEAM-1748. Original Jira may contain additional context.
Reported by: altay.