Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Processing large XML field out of Oracle DB

Hi, I have a situation where we have a source oracle table that contains a CLOB whose XML data I need to extract and parse out a few fields that would then end up in target fields in Redshift. I'm not really sure how to accomplish this. Another complication is the fact that this field value can be large and exceed the size of redshift's VARCHAR, etc limit, and it appears that the only option for the sql component is to create a table based on the query.

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Erich,

Redshift has no equivalent datatype to Oracle’s CLOB or XMLType, so you’ll have to parse out the fields before loading the data into Redshift.

You should be able to do this using an XMLTable expression in a Matillion RDS or Database Query component.

Best regards,
Ian

Post Your Community Answer

To add an answer please login