I'm setting up an Amazon Redshift Spectrum pipeline, what is the best way to troubleshoot redshift connectivity and permission errors?
I'm setting up an Amazon Redshift Spectrum pipeline, however, it asks for a Workgroup for Redshift Serverless, but I am using regular Redshift which does not have a Workgroup, so what do I enter?