Amazon Redshift paired with Tableau has fundamentally been changing the way people deal with their ever-growing data assets. First, you can connect to your Redshift instance within seconds and analyze data simply by dragging and dropping. Second, it empowers non-technical users to perform complex analyses against their big data in the cloud. Finally, Tableau Online’s ability to connect live to Redshift means organizations can deploy an entire analytics solution hosted in the cloud.
Performing ad-hoc live queries against millions and even billions of rows of data can require some advanced planning to ensure optimal performance. In our new whitepaper co-developed with Amazon, Tuning your Amazon Redshift and Tableau Software Deployment for Better Performance, we have worked closely with Amazon to offer optimization solutions for both Redshift and Tableau that will help ensure the best performance for our users.
In this whitepaper, you will find tips on monitoring query performance using Tableau’s Performance Recorder, ways to ensure responsiveness in Tableau by minimizing both query complexity and size, as well as optimal connection best practices. It also offers guidance on optimizing Redshift performance in areas such as cluster sizing, encryption, and compression as well as other key considerations.
As always, we’d love to hear your feedback. Happy reading!