JAN 05 2017
- New Feature: Enhanced Tracking Statistics
Ever wondered where your data was after Stitch pulled it from the source but hadn’t arrived in your data warehouse yet? When the next sync will start? How many rows you’ve loaded today? This information (and more) is now available - just click on any individual integration to experience this… experience.
DEC 15 2016
- New Feature: Database View Replication Support
With the new year fast approaching, the Stitch engineers wanted to slip in a last update or two to the product before the ball drops. Today, customers can now see and replicate views for database integrations - just pick a primary key and replication method. Enjoy!
DEC 07 2016
- New Feature: Rejected Records
Occasionally, Stitch encounters data that it can’t load into a data warehouse for a variety of reasons - dates that fall out of range, table names that are too long, etc. Stitch now persists these rejected records into a special table (_sdc_rejected) for each integration, and includes the reason for the rejection and as much of the data as it can fit.
NOV 22 2016
- New Feature: In System Notifications
When things go wrong, as they occasionally do, Stitch already sends an email notification about this issue. Now, those notifications are available inside the Stitch interface as well. Just click on the “Notifications” tab at the top of the page to see your active notifications.
NOV 03 2016
- New Feature: BigQuery and Postgres now in Open Beta
If Redshift is not the right data warehouse for you, then we’ve got you covered. Our BigQuery and Postgres data warehouse integrations are now in open beta - and you can set them up in Stitch today! Both are now available during destination selection in the onboarding process.
NOV 03 2016
- New Feature: Historical Sync Enhancements for SaaS Integrations
Not sure how far back Stitch reaches into a SaaS integration? Need more historical data for your analysis? Made a change and need to go get all the data again? Now you can do it - Stitch users can now configure during setup how far back a SaaS integration will replicate, and can review, reset, and re-sync from that date at anytime. Check it out under Integration Settings.
OCT 18 2016
- Changed: Re-using Schema Names from Deleted Integrations
Delete an integration, and still attached to the schema name that went with it? Now you can re-use schema names from deleted integrations when you set up new ones.
OCT 12 2016
- New Feature: Reset Replication Keys for Individual Tables
Hot off the heels of support for resetting the replication keys for an entire database integration, Stitch now offers the ability to do it on a per table basis. Head down to the “Table Settings” for an individual table and you’ll see the new button.
OCT 11 2016
OCT 11 2016
- New Feature: Support for the LONGNVARCHAR DataType
Up until now, Stitch supported VARCHAR, NVARCHAR, and LONGVARCHAR. Today we’ve added support for the crazy uncle of the VARCHAR family, LONGNVARCHAR! Just a note - if you have existing database integrations that have this datatype, you’ll need to go in and specifically track it. Any new integrations will automatically track it.
OCT 10 2016
- New Feature: Panoply.io Now Available
Interested in Redshift but don’t want the hassle of maintaining an Amazon Web Services account? Exciting news - Stitch has partnered with Panoply.io to bring their managed data warehouse solution to our users - including a free tier with up to 10 million rows per month!
OCT 07 2016
- New Feature: Salesforce Object Field Selection
Salesforce objects with a lot of fields can lead to unnecessarily wide tables when all you care about are a few of the fields. Starting today you can select which fields to sync from your Salesforce objects, giving you more control to keep your warehouse clean and simple.
SEP 29 2016
SEP 23 2016
SEP 14 2016
- New Feature: Integration Bonanza
Lots of integration related news today. We’ve opened up the public beta for our new Google Analytics integration. The new GA integration allows you to create custom datasets using GA’s metrics and dimensions. Also, our Segment, Recurly, Trello, Pardot, and Intercom integrations have come out of beta and are ready for some ETL’ing. Now get out there and start moving some data.
SEP 12 2016
- Changed: Change Replication Keys (Mongo Databases)
If the wrong replication key is set for a Mongo database incremental replication, you can now change it to the correct key within the Stitch interface. Note that changing the key will force a full re-sync of the table.
SEP 07 2016
- New Feature: Added NetSuite Deletion Log
The NetSuite integration now includes a table called netsuite_deleted which contains a row for every deleted record that supports deletes. Accounting for deleted records is especially important if you’re performing any sort of aggregate function - for example, totaling invoices or balancing your books. Learn more about utilizing the NetSuite deletion log in our docs.
SEP 06 2016
- New Feature: Added Zendesk Group Memberships
The Zendesk integration now includes a zendesk_group_memberships table containing information about the groups your Zendesk agents are members of. Fields in this table include the group membership ID (id), URL, name, deletion flag, created_at and updated_at dates.
SEP 02 2016
- New Feature: Reset Replication Keys (for Database Integrations)
Need to completely re-sync all incrementally replicated tables in a DB integration? Now you can(!) via the Integration Settings page on any MySQL, Postgres, SQL Server or Mongo integration. Take care though - the re-synced rows count towards your monthly caps.
AUG 23 2016
- Bugfix: Redshift Loader Version 2.0.2
This release ensures precision for boolean data types, specifically that false values are accurately displayed as false (instead of null) in Redshift.
AUG 10 2016
- New Feature: Change an Integration Name
Don’t like what you named your integration? You can now fix that. Integration names can be edited within the settings for each respective integration. This does not change the name of the schema in your data warehouse.
AUG 10 2016
- Bugfix: Redshift Loader Version 2.0.1
This release increases the precision and scale of decimal types in Redshift, changing from the Redshift default of
AUG 08 2016
- New Feature: Added Changelog
We added a changelog to stitchdata.com to make it even easier to learn about Stitch product updates. Very meta.
AUG 05 2016
- New Feature: Support for JSONB and ARRAY Postgres data types
All Postgres fields of type JSONB and ARRAY may now be synced from integrations page. These fields will be converted to strings in Redshift.
AUG 01 2016
- New Feature: Redshift Loader Version 2.0
Now 50% Redshiftier, along with these improvements: faster loading for high volume data streams, transactional upserts, and NO MORE VIEWS - data is materialized into tables directly in the target schema, and these tables are never dropped.
AUG 01 2016
- Changed: Getting Stitched
Everything that used to be called RJMetrics Pipeline is now called Stitch. Basically, a big
s/RJMetrics Pipeline/Stitch/gon our codebase.