We just expanded the types of columns you can use as a bookmark to set a table to Incremental Replication. You can now use MEDIUMINT, SMALLINT, and TINYINT columns as replication keys.
Good question. How Pipeline replicates data for the new column depends on the type of replication method the table is using. In this article, we explain what you can expect to see for each method and how to ensure new data is captured for existing rows.
We got word that some users were confused when it came to configuring their cluster, specifically when it came to the VPC settings. We made some updates to this article to address this.
Remember: if you created your AWS account after December 3, 2014, you do not have to spin up a VPC before you can launch a cluster. Your AWS account already includes a default VPC that you can use.
If you need some help figuring out how to best handle deleted rows in your database, this short article is for you.
Having trouble connecting your data warehouse to Pipeline? If a connection error has you stumped, this troubleshooting article might be just what you need to resolve the issue.
Noticed that some of your columns aren't syncing to your data warehouse? Null values may be the root cause.
We included some incorrect steps when writing the setup instructions for connecting Heroku Postgres databases to Pipeline. This article has been rewritten to reflect the correct procedures. We're sorry for the inconvenience, but we are grateful to the client whose feedback brought it to our attention.
This article has been updated to include information about the Zendesk organizations, macro, groups, ticket fields, and tags tables.