Destination Redshift: improve check performance

[VitaliiMaltsev]

Improve check method connection time if possible

[Phlair]

@VitaliiMaltsev could you add some basic context stats to this issue please
e.g.

Currently seeing check times ~ x seconds / minutes

Would like to get check times down to ~ x seconds

[VitaliiMaltsev]

@Phlair @misteryeo
Check method for Redshift Destination performance test results:

---

Master branch
Standard inserts ~ 3.2 seconds
S3 staging ~ 5.8 seconds

Buffering strategy
Standard inserts ~ 3.3 seconds
S3 staging ~ 5.8 seconds

AbstractJdbcDestination check improvement
Standard inserts ~ 2.4 seconds
S3 staging ~ 4.6 seconds

no additional implementation is required for this task. The performance of the check method for all JDBC destinations will be improved as soon as this PR is merged.

[misteryeo]

Thanks @VitaliiMaltsev - it looks like there are outstanding comments on the PR so it's not ready to be merged?

[VitaliiMaltsev]

Thanks @VitaliiMaltsev - it looks like there are outstanding comments on the PR so it's not ready to be merged?

@misteryeo yes, the PR is currently in Airbyte review status, outstanding comments were replied today

[grishick]

@VitaliiMaltsev I've approved the PR

[VitaliiMaltsev]

published and merged in scope of #12820