AWS Redshift Workload Management

by fflood   Last Updated August 14, 2019 02:06 AM - source

I am planning an AWS Redshift (RS) data warehouse and expect to have mix of longer-term jobs (60%) and short-term jobs (40%). The plan is to use workload management (WLM) and create multiple queues to manage the jobs (easy). Recently I saw an architecture that creates dedicated RS DB's for specific users as a way to manage workload, but this seems expensive and inefficient. Question: Any experiences where dedicated RS DB's were a better choice than using single RS DB with WLM?

Tags : aws redshift

Related Questions

Restricting the size of schema in Redshift

Updated July 27, 2015 13:02 PM