SUPPORT.TWILIO.COM END OF LIFE NOTICE: This site, support.twilio.com, is scheduled to go End of Life on February 27, 2024. All Twilio Support content has been migrated to help.twilio.com, where you can continue to find helpful Support articles, API docs, and Twilio blog content, and escalate your issues to our Support team. We encourage you to update your bookmarks and begin using the new site today for all your Twilio Support needs.

Redshift Serverless support and stl_load_commits permission error in Segment

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 

 

 

Have more questions? Submit a request
Powered by Zendesk