How to improve performance of "UPSERT"s when running "COPY commands December 07, 2021 by Abe Dearmer UPSERT is the operation to merge new records with existing records using primary keys on a table. While some RDBMSs support a single UPSERT statement.
What is the U.S.-EU Safe Harbor Program? December 07, 2021 by Abe Dearmer In a nutshell, the Safe Harbor program enables certified American companies to safely handle personal and potentially sensitive data from European customers and partners.
Three Things to Consider When Making Investments in your Big Data Infrastructure December 07, 2021 by Donal Tobin Let’s go over what you need to consider when making the necessary technological investments to support your data infrastructure.
A Brief History of Data Analysis December 07, 2021 by Mark Smallcombe Let's take a short journey together through the history of data analysis.
Cognitive Biases in Data Science December 07, 2021 by Abe Dearmer We often think of “data” as an objective form of information, as something we just observe and record into computers and write on spreadsheets. In reality...
Now Available: Postgres as a Data Source December 04, 2021 by Donal Tobin Integrate.io has been offering MySQL replication to Amazon Redshift for the last 18 months. We’ve heavily focused our efforts on MySQL to not only continually improve it, but also provide...
Customer Spotlight: Darwill December 04, 2021 by Abe Dearmer At Integrate.io, our greatest asset is our customers. We love our customers and they love us, so we are launching a new blog series called, Customer Spotlight where each month...
Data Engineering as a Service - how we help startups make sense of their data December 03, 2021 by Abe Dearmer This blog is to help guide some early teams with tight engineering resources. If you have growing data, you need to view it in one place, analyze it effortlessly and...
Data Engineer vs. Software Engineer: What is the Difference? August 27, 2021 by Abe Dearmer Data engineer vs. software engineer: which is right for you? We go over the differences between data engineers and software engineers.