Our Matillion jobs have Python script component. I would want to replace it with Run Serverless component which has AWS Lambda

Matillion ETL
1

Why I want to use? By using Python script component I am unable to handle Excel workbook as I have to download Openpyxl or XLRD. Downloading module in Python script is not possible.

 

So, I have downloaded "Run Serveless" MELT file. I have tried to Import it in Shared jobs. I am getting the below error.

 

 

What action I can take to make it possible and use AWS Lambda instead of Python Script?

2

Sorry, error is here

 

Unable to import from a newer version. Exported from '1.54.9', trying to import into '1.51.7'

3

I have read this statement from Import- Export Documentation. Under NOTES this is mentioned - "You cannot import resources from a newer version Matillion ETL instance into an older version Matillion ETL instance."

 

https://documentation.matillion.com/docs/2734441

 

This is the answer I believe. Please confirm.

4

Hi @KalyanB (Customer)​ - To use Openpyxl or XLRD, you can use pip install by logging into instance with SSH and using the pip install command, then just the usual import in the script. If using Python 3 see: https://documentation.matillion.com/docs/2234735#additional-modules-python3-only. If using Python 2 see: https://documentation.matillion.com/docs/2234735#additional-modules-jython-python2-only