Pivot Array Field in Postgres Source

[JoshMcNatt]

I need to parse/pivot an array column into individual columns. The source is Postgres. I cannot get it to work as the fields are not fixed length

[OritA · Accepted solution]

Hi, 
Looking at the documentation under the Postgres supported  data type the array column are replicated as NCLOB and therefore it is not possible to define transformation rule on them. However for more detailed investigation and better undersanding of the need, we would recommend you to open a case in our support portal and include the table DDL and the task json with the transformation rule you are trying to define so we can see if there is any other way to achieve your need. 

thank s& regards,

Orit