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

Python Script Python 3 and Jython

Hi,

I use Python Script Python 3 to retrieve JSON data with certain API. In order to insert data into Redshift table I need to use Python Script Jython. How to transfer variables between them? Is there any other approach?

Thanks,
S

1 Community Answers

Matillion Agent  

Ian Funnell —

Hi Sam,

Matillion’s API Query is designed to acquire data from a JSON API and copy it into Redshift.

There are ways to transfer data between Python 3 and Jython components (using variables), but you’ll get much faster throughput using the API Query, which is dedicated for this purpose.

We have a documentation series on this component. Please start with Writing API Profiles
Then also:

Best regards,
Ian

Post Your Community Answer

To add an answer please login