Setting Up Amazon Redshift Spectrum Pipeline Without Workgroup

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?

2 comments

kapa.ai
APP
·
·
Hi David F., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
kapa.ai
APP
·
·
Based on the information provided in the knowledge sources, it appears that the documentation primarily focuses on setting up a Redshift Spectrum pipeline for Redshift Serverless, which uses Workgroups. However, you're using regular Redshift, which doesn't have Workgroups.Unfortunately, the knowledge sources don't contain specific information about how to set up a pipeline for regular Redshift in this scenario. The documentation seems to be tailored for Redshift Serverless, as evidenced by this quote from the Redshift Spectrum setup guide:"Redshift - Workgroup Arn: Workgroup ARN for Redshift Serverless."Given that you're using regular Redshift and not Redshift Serverless, the setup process might be different, and the knowledge sources don't provide clear guidance on how to proceed in your specific case.I recommend reaching out to Mixpanel's support team for assistance with setting up a pipeline for regular Redshift. They should be able to provide you with the correct steps or alternative fields to use in place of the Workgroup ARN.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.