We are having a requirement where we are supposed to populate entire data(including tags) from an XML to a column in an Redshift database.
->Redshift database has Target table with 3 columns in it (ShowId,Data,Update).
->ShowId should be populated with the id (from Xml source).
->Date Column should contain system date(which i'm able to get)
->Update column should contain entire data from <show> to</show>(including tags)
Please find the attachment below.
Can some one help me on this please .
Thanks in advance