Getting started

Connecting an Amazon Redshift Destination to Stitch

Connect an Amazon Redshift destination to your Stitch account.


Using Amazon Redshift

Understanding Loading and Row Usage for Nested Data Structures Depending on the type of destination you’re using, Stitch may deconstruct nested data structures into relational 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

Destination Loading Error Reference Resolve errors related to loading data into your Stitch destination.

Destination Connection Error Reference Resolve errors related to connecting to your Stitch destination.

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.

Amazon Redshift Data Loading Reference Learn how Stitch will load data from your integrations into Stitch’s Amazon Redshift destination.

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

Stitch System Table and Column Reference 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.