Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Python script


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

Matillion Agent  

David Lipowitz —

Hi Bharathi,

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 not be separated by a comma. Here’s an example from their documentation

        "id": 1006410,
        "title": "Amazon Redshift Database Developer Guide"
        "id": 100540,
        "title": "Amazon Simple Storage Service Developer Guide"

A file containing the data above could be loaded into a table with two columns called id and title for example.

I hope that helps and please let us know if you have any more questions.

Best Regards,

Post Your Community Answer

To add an answer please login