Data Cleansing

[pinkstondevin]

Hello,

I'm reading through the Admin API and wondering what the best route would be to return data in a csv/json form that could be exported to a data cleansing solution.  For instance if i have a vdb with a table i would like to cleanse, what is the best route to return data in csv/json format that I could pass to our cleansing solution?

Thank you!

[shawkins]

Starting with 8.3 you can produce JSON using the jsonArray_Agg, jsonArray, and jsonObject functions - https://docs.jboss.org/author/display/TEIID/JSON+Functions and https://docs.jboss.org/author/display/TEIID/Expressions

Otherwise to produce CSV, you'll likely want to use TEXTAGG - https://docs.jboss.org/author/display/TEIID/Expression

[pinkstondevin]

Thank you Steven!