How to call python script in SnapLogic
Hi Team,
I need to call below sample python script from snaplogic.
or is there a way to call .py file in snaplogic
import pandas as pd
################Can be snap logic pipeline##############...
Forum Discussion
How Can I get the The hostname of Remote Python Executor.
@sanam Hello again! I replied on your separate thread about the RPE hostname (Remote Python Snap Account). What I want to add to this thread is that if you need a third-party Python library the Remote Python Script snap is the way to go and the RPE images we maintain already have Pandas.
From a design perspective, is there a reason your thinking about making the SQL connection in Python rather than using the SQL Server snap pack for the read, then passing the data into the RPE snap for processing with Pandas?
Hi @rsramkoski
Even if he goes with RPE and Pandas, … then what about pyodbc? Is it supported in RPE?
If you check the py-libs:
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/615415845/Remote+Python+Executor+RPE+InstallationNot only pyodbc, but all the other python connectors to the databases - how are they supported via RPE?
/Igor
@igormicev We do not restrict which third-party Python libraries work in the RPE snap. Custom scripts like this though would be outside the scope of our Support team, meaning they need to be supported by the team that develops them. What is the driving factor to use pyodbc or another Python library to connect to SQL Server instead of the SQL Server snap pack or JDBC snap pack?
