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?
1 Community Answers
Ian Funnell —
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.