Question
Does Segment support Redshift Serverless, and how can I resolve this error?
Product
Twilio Segment
Environment
Segment Console
Answer
Segment does not currently support Amazon Redshift Serverless as a native destination. While you can set up a Redshift Serverless connection in the Segment app, Segment is unable to query Redshift’s system tables (such as stl_load_commits) that are required for standard data load operations. This limitation causes permission errors during data loads, as Redshift Serverless restricts access to these tables.
As a workaround, you can use a Destination Function to send data to Redshift Serverless. This approach allows you to forward events to external APIs or services with custom logic, but it does require Node.js development experience.
Additional Information
- Segment’s Product team is aware of requests for Redshift Serverless support. You can request this feature, but there is no ETA for native support.
- For guidance on Destination Functions, see the Segment Functions documentation, the functions-library repo, and the Segment University Functions Course.
- Once Redshift Serverless support is available, Segment documentation will be updated.