Engineering team has determined this as an enhancement (which is kind of what we expected) as this is a relatively new feature in Redshift. There is an internal enhancement created for this to determine what it takes to support Redshift procedures and this (if feasible) will be included in future releases.
Hi Team, can you please update on this on when this can be Implemented, we have ended up in a situation where we need to use amazon redshift procedure to improve the performance. it will be good if you can share the updates on this.