Getting started

Connecting an Amazon Redshift Destination to Stitch

Connect an Amazon Redshift destination to your Stitch account.


Using Amazon Redshift

Nested JSON Data Structures & Row Count Impact MongoDB and many SaaS integrations use nested structures, which means each attribute (or column) in a table could have its own set of attributes. Depending on the type of destination you’re using, Stitch may deconstruct these nested structures into separate tables.

Applying Encodings, SORT, & DIST Keys in Amazon Redshift Want to improve your query performance? In this article, we’ll walk you through how to use encoding, Sort, and Distribution Keys to streamline query processing in your Amazon Redshift data warehouse.


Troubleshooting

AWS & Redshift I/O Connection Errors While typically transient, I/O errors arise from connection issues between Stitch and your data warehouse. If persistent, these errors may be indicative of a larger issue.

Redshift VACUUM Errors If you received a VACUUM notification, it means that Stitch hasn’t been able to successfully complete VACUUM some tables in your data warehouse for more than 10 days.

Redshift View Dependency Errors If you’ve received a ‘Dependent Views’ error for your Redshift or Panoply data warehouse, you may need to temporarily drop dependent objects.


Reference

Amazon Redshift Destination Reference Reference documentation for Stitch’s Amazon Redshift destination, including info about Stitch features, replication, and transformations.

Destination & Integration Compatibility Verify your integrations’ compatibility with your data warehouse.

System tables and columns When data is loaded into your destination, Stitch will create some additional columns and tables. Learn about these system columns and tables and how Stitch uses them.

Stitch and Destination Reserved Keywords A reference of Stitch and destination-reserved keywords.


Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.