In some situations, Stitch will interpret
TINYINT(1)/boolean columns from MySQL as
BIT. In this doc, we explain why and provide some simple workarounds.
Want to learn the ins and outs of how data is loaded into a Redshift destination? In this rollup doc, you'll find the expected behavior for the most common situations Stitch encounters when loading your data.
Not sure how Replication Keys work or how to select the best one? Everything you need to know is in this guide, along with some of our recommendations.
We recently added the ability to re-use schema names from deleted integrations to Stitch. For detailed info on how this works (and the associated gotchas), check out the doc linked above.
Default start dates for SaaS integrations can now be changed in the Stitch app. In this doc, we cover not only how to do this, but everything you need to make an informed decision about syncing your historical data.
Need some help connecting your Postgres destination? Depending on your budget and technical expertise, there are a variety of options to choose from. The three docs linked above will walk you through three of the most common setups.