Important! Version 1.0/1.1 Deprecation
Versions 1.0 and 1.1 of the Redshift data warehouse have been deprecated as of January 1, 2017. If you're unable to access your account, you may have been using one of these deprecated versions.
To continue using Stitch, you'll need to create a new account.
Welcome to version 2 of Stitch's Redshift data warehouse!
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:
_rjm) and then views for the new data would be created or updated. In v2, data will be stored directly in the tables in your integration schemas.
_rjmschema has been deprecated. This, coupled with storing data directly in integration schema tables, will drastically reduce issues with view creation and the time spent troubleshooting errors.
_sdccolumns? These columns replace the staging
_rjmschema from previous versions. Any column prepended with
_sdcis used by Stitch to replicate your data.
_rjm- would be added. These columns will continue to be added to tables, but will now be prepended with
_sdcinstead. For example:
_sdc_source_key_idin version 2.
_sdc, they will not be replicated to your data warehouse. Stitch will reserve any columns of this form for internal use.
While we’re at it, here’s a recap of what was released in v1:
VARCHARdata 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.
Id- to prevent collisions. Now, data type names will be used instead.
DATEdata types; the other is
TIMESTAMPs. Stitch will add the data types to the column names, naming them
Switch your Redshift data warehouse over to v2 before January 1, 2017 by following the instructions in this article: Migrating to Redshift v2.