Query SQL database and download the output to an S3 bucket in json format

Matillion ETL
1

Hi, anyone tried exporting a query results from SQL DB to a bucket in S3 in json format?

 

I use the RDS Query component but it doesnt have a json option for me. Also the non-compressed file in S3 seems to be in CSV format but doesn't have any column header. Do you have any solution to: 1. export file in json format OR 2. export file in csv format but still keep the column header

2

Hi @CP872896​ ,

have a look at the "S3 Unload" component: https://documentation.matillion.com/docs/2167231

It offers options to 1) choose JSON as output format or 2) format CSV files to your needs, for example with headers.

Good luck and let us know how that worked for you!