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

Python script

Hi,

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.

Thanks,
Bharathi.

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,
Dave

Post Your Community Answer

To add an answer please login