Your success with Amazon Redshift is our business
Let’s get you the tools you need when you’re responsible for the data crown jewels
Start understanding where your data is stuck, so you can get it flowing again.
Get back in control of your cluster and discover insights you can act on.
We’ve seen so many clusters, we’re confident we can solve your problem.
“Your product tells me what I want to know.”
Predict future storage needs
With business growth comes data growth. More data leads to more analysis. When joining data sets in Redshift, analysts and algorithms create new, derived data. Which can be an order of magnitude larger than the original source data. Predict future storage needs with our Storage Analytics. Understand data growth rates, and identify opportunities where to save on storage.
DISK UTILIZATION Analyze disk use by node, database, schema and table. Predict storage needs with data growth rates for each individual table.
SCHEMA & TABLE SIZES Identify the top tables by size per schema and database. See all tables which need vacuuming to reclaim and reuse space.
TABLE SORTING Sort all tables by disk utilization and data growth rates. Spot tables with accelerating growth that could fill up your cluster.
VACUUM SCRIPTS Save time by downloading and running custom vacuum scripts. Reduce the storage footprint of your data.
Make every query fast & efficient
Even with the power of a large Redshift cluster, queries can still get slow. Concurrent queries are competing for the same memory resources. When queries are starving for memory, they fall back to disk. Getting concurrency settings right in the WLM is only half the battle. The other half is determining the right memory allocation for your workloads. With our Memory Analytics.
MEMORY STATS Understand what users are running expensive queries that are consuming too much memory.
DISK-BASED QUERIES See which queries are starved for memory and are falling back to disk. Debug the full text query, including the precise amount of memory it uses and the amount of rows the query scanned.
MEMORY DETAILS Drill down into the single, full-text query and its concurrency. See what other queries were running at the same time, competing for memory.
Cut queue wait times for your loads and queries
Throughput Analytics help you discover the Workload Management (WLM) configuration in Redshift. In context with cluster usage, you start understanding where data is not flowing. Maximize cluster throughput by finding the right Workload Management (WLM) configuration in Redshift.
WLM DETAILS Intuitive auto-discovery of WLM queues, user groups, memory and concurrency settings. See all your cluster settings in a single view.
CONCURRENCY ANALYSIS Identify concurrency bottlenecks that slow down your queries. See with time-series data when queries get stuck waiting in the queue.
QUERY GROUP SUMMARY Isolate key queries with automatic grouping. Track their performance over time and identify opportunities to increase query speeds.
Uncover actionable insights
Asking simple questions about your queries and loads shouldn’t be difficult. Which users write the most expensive queries? What’s the average query latency? How much time do queries wait in the queue? Which transformations are too slow or failing? Making sense of thousands of varying data points takes a lot of time and resources. That’s why intermix.io allows you to group queries and transfers by common traits. To measure performance and find insights you can act on.
LOAD & QUERY ANALYTICS Get times-series reports for your data transfers and queries. With details on transfer rates, counts, queue and execution times.
ADVANCED SEARCH Powerful full-text search capabilities across all queries, data transfers, and user activity. Narrow down your search with filters and complex rules.
TOP LOADS & QUERIES Identify the top tables by size per schema and database. See all tables which need vacuuming to reclaim and reuse space.
QUERY DETAILS Sort all tables by disk utilization and data growth rates. Spot tables with accelerating growth that could fill up your cluster.
Start collaborating and sharing performance insights with your team members.
Sometimes you want to track your key queries. See if there’s a spike in memory usage or if they’re slowing down. Or simply see how your queries are running faster because you’ve tuned your cluster. With Saved Searches, you can do that.
CUSTOM SEARCHES Save your searches to create personal dashboards relevant to achieving your performance goals.
TIME PICKER Use different time-based views of your performance data to create baselines and benchmarks.
COLLABORATION Share saved searches with your team via unique URLs, e.g. in Slack. Add custom descriptions and tags for better collaboration.
Get immediate help on your most complex Redshift problems
The use cases for Redshift differ from customer to customer. Classic reporting, log analysis, fraud detection, predictive apps – the list is endless. With different use cases come different questions. Problems are sometimes so unique and pressing, they need an immediate answer. Get instant help from our Redshift experts. We’ve seen so many Redshift clusters, we’re confident that we can solve your problem. Plus, we’re drinking our own champaign. Our back-end runs on Redshift, across three continents, with dozens of different clusters and thousands of nodes. And we’re using intermix.io to to manage intermix.io.
SLACK CHANNEL Get help via a dedicated Slack channel that feels like an extension of your data team. Iterate faster, and get answers on your Redshift configurations.
TRAINING &WORKSHOPS Train your data team on Redshift with our dedicated workshops. With custom drill downs into your data model and workloads.
COMMUNITY Network and exchange with other Redshift users during our frequent on-site and virtual customer events, including once a year during AWS Reinvent.
Stress free security and scalability
Redshift has your “data crown jewels”. We help you to put your data work. Our cloud-based platform doesn’t require planned downtime. We have limitless capacity to store your performance data and make it accessible in real-time. We follow industry-standard protocols for storage, backup, and redundancy. And we safeguard all information with government-level encryption. Like the Queen’s Guards.
WORLD CLASS SECURITY We protect all information with government-level encryption. Our security program—people, process, and privacy—is designed to protect your cluster .
DATA PRIVACY With our multi-region infrastructure, you can run intermix.io in a region of your choice, aligned with where your data resides.
DESIGNED FOR DEVELOPERS Our REST APIs make it easy to connect the dots between all the solutions in your ecosystem. We know that because we built our own dashboard on top of our API