question Converting SQL record to JSON in Support Questions

question Converting SQL record to JSON in Support Questions https://community.cloudera.com/t5/Support-Questions/Converting-SQL-record-to-JSON/m-p/336660#M232338 I am trying to read records from a SQL source and put them in a s3 bucket. Currently my flow is as follows:QueryDBTableRecord (SQL record to CSV) >>> ConvertRecord (CSV to JSON conversion) >>> JOLT (Rarrange the json to suit) >>> PutS3Oject (Duh) Firstly is this a valid route? It seems like there has been a lot of changes in the last few years and many tutorials are outdated and I think this is the current best practise. Secondly if this is correct, I'm struggling with the JOLT format. I want to transform this:<img src="https://community.cloudera.com/t5/image/serverpage/image-id/33624iCF7792FB7288CE34/image-size/medium?v=v2&px=400" role="button" title="Katsuki_0-1645354319308.png" alt="Katsuki_0-1645354319308.png" />into this:<img src="https://community.cloudera.com/t5/image/serverpage/image-id/33625iBAADF23B36333F02/image-size/medium?v=v2&px=400" role="button" title="Katsuki_1-1645354339178.png" alt="Katsuki_1-1645354339178.png" />I've made a start with:<img src="https://community.cloudera.com/t5/image/serverpage/image-id/33626iE488CCA42B94B0B5/image-size/medium?v=v2&px=400" role="button" title="Katsuki_2-1645354363547.png" alt="Katsuki_2-1645354363547.png" /> And this moves the two items up to the upper level as desired but I am struggling to make pairs from the data points instead of getting a flat array.  Sun, 20 Feb 2022 10:53:55 GMT Katsuki 2022-02-20T10:53:55Z