Pivot with Redshift

Matillion ETL
1

Hi,

 

We have a use case where we need to pivot data.

 

I note that Matillion does not support Pivot for Amazon Redshift

https://docs.matillion.com/metl/docs/2974117/#properties

 

Redshift supports pivoting now:

https://aws.amazon.com/about-aws/whats-new/2022/02/amazon-redshift-support-pivot-unpivot-sql-operators/

https://docs.aws.amazon.com/redshift/latest/dg/r_FROM_clause-pivot-unpivot-examples.html

 

Are there any plans to add support into Matillion?

 

Thanks,

Philip

2

Hi Philip,

 

You can post this as an idea on idea portal:

https://metlcommunity.matillion.com/s/idea/Idea/Recent

 

 

3

That's a great suggestion, @ASD!

We've recently celebrated 32 implemented ideas raised by the Community — and there are more to come, @philip.wroblewski​

Cheers,

Chika