Ok, so in the end the issue was fixed by moving from redshift driver (I need to actually connect to redshift) to postgres one "org.postgresql" % "postgresql" % "42.1.1"
and with that in dependencies and having actually postgresql conn string I was able to solve my issue.
CLICK HERE to find out more related problems solutions.