Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Redshift Data Warehouse v1 Release Notes

Important! Version 1.0/1.1 Deprecation
Version 1.0 of the Redshift data warehouse has been deprecated as of January 1, 2017. If you're unable to access your account, you may have been using this deprecated version.

To continue using Stitch, you'll need to create a new account.

Welcome to v1 of the Redshift data warehouse!

Version 1 Features

We’re excited to announce a number of new features that will vastly improve your Stitch experience. Here’s a look at what’s included in this release:

  • Genuine multiple data type splits. If there is more than one data type in a single column, Stitch will split the data into multiple columns: one for each data type.
  • Automatic VARCHAR widening. Up to 65k characters, VARCHAR data types will automatically be widened to the smallest possible amount without truncation. This means if a data point with 65 characters comes in, Stitch will automatically widen the column to 128 to accommodate it.
  • Hashed column names are a thing of the past. Previously, Stitch would hash column names that only differed by case - consider Salesforce’s infamous use of id and Id - to prevent collisions. Now, data type names will be used instead.

    For example: an integration sends over two columns. One is named updated_at and contains DATE data types; the other is Updated_At and contains TIMESTAMPs. Stitch will add the data types to the column names, naming them updated_at__date and updated_at__timestamp, respectively.
Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!