Having used Redshift considerably in the past and experienced significant pain with many aspects of it, I would stay away. There are other much better options,

Having used Redshift considerably in the past and experienced significant pain with many aspects of it, I would stay away. There are other much better options, ideally Snowflake.