I got to solve this, apparently I was missing the inbound rule to allow access to the default port Redshift Serverlesss uses, 5439 , so I modified the security group attached to the Workgroup to allow this port.
2 Likes