# Pivot with Redshift

**URL:** <https://matillioncommunity.discourse.group/t/pivot-with-redshift/2323>\
**Category:** Matillion ETL\
**Created:** [October 19, 2023, 9:43pm UTC](https://matillioncommunity.discourse.group/t/pivot-with-redshift/2323 "2023-10-19T21:43:25Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![philip.wroblewski](https://avatars.discourse-cdn.com/v4/letter/p/c68b51/32.png) [@philip.wroblewski](https://matillioncommunity.discourse.group/u/philip.wroblewski)\
**Post date:** [October 19, 2023, 9:43pm UTC](https://matillioncommunity.discourse.group/t/pivot-with-redshift/2323/1 "2023-10-19T21:43:25Z")

</div>

Hi,

&nbsp;

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

&nbsp;

I note that Matillion does not support Pivot for Amazon Redshift

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

&nbsp;

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

&nbsp;

Are there any plans to add support into Matillion?

&nbsp;

Thanks,

Philip

---

<div class="post-metadata">

**Author:** ![ASD](https://sea2.discourse-cdn.com/flex002/user_avatar/matillioncommunity.discourse.group/asd/32/1323_2.png) [@ASD](https://matillioncommunity.discourse.group/u/ASD)\
**Post date:** [October 20, 2023, 5:04am UTC](https://matillioncommunity.discourse.group/t/pivot-with-redshift/2323/2 "2023-10-20T05:04:00Z")

</div>

Hi Philip,

&nbsp;

You can post this as an idea on idea portal:

[https://metlcommunity.matillion.com/s/idea/Idea/Recent](https://metlcommunity.matillion.com/s/idea/Idea/Recent)

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![ChikaMatillionCommunityMgr](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@ChikaMatillionCommunityMgr](https://matillioncommunity.discourse.group/u/ChikaMatillionCommunityMgr)\
**Post date:** [October 20, 2023, 4:18pm UTC](https://matillioncommunity.discourse.group/t/pivot-with-redshift/2323/3 "2023-10-20T16:18:40Z")

</div>

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](https://matillioncommunity.discourse.group/u/philip.wroblewski)​

Cheers,

Chika