Integration tests executed on a real deployment as part of the CICD - Redshift Datasets

[dlpzx]

Same as for #1220.

Wait for #1409 to be completed to use as reference

This issue is to track the progress for the Redshift Datasets module
It has its own dedicated issue because of the challenge of testing existing redshift infrastructure