I have created the json data using python script in matilion and I was trying to move json data to amazon redshift table. But I couldn't find the correct way to do that. Kindly help me out to move those json data to table.
1 Community Answers
David Lipowitz —
I’d recommend getting your JSON file up to S3 and loading it from there using our S3 Load Component.
Please note that Redshift requires that your JSON file be formatted with a separate objects for each record, and that these objects should be separated by a comma. Here’s an example from their documentation