At intermix.io, we run a fleet of over ten Amazon Redshift clusters. In this post, I’ll describe how we use AWS IAM authentication for our database users. AWS access is...

Everything from cloud-based data warehousing solutions like Amazon Redshift to data storage techniques like database replication have evolved due to these massive strides in technology.

A first look at the new RA3 Amazon Redshift node type Table of Contents Introduction Specs Copy Performance I/O Performance Real-world performance Separation of Storage and Compute Conclusion Introduction Today...

With data and analytics being a core function of businesses today, it's essential to have the right data consultants on your team. See this overview to learn more.

How clean your data is can impact your data warehousing ROI. Also, it influences the accuracy and reliability of your business analytics. So, what is data cleansing, and why does...

Why do so many data migration projects encounter serious challenges? Often it’s because practitioners fail to observe some of the well-established data migration best practices.