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###############333333
import pyodbc
conn = pyodbc.connect(‘DRIVER={ODBC Driver 13 for SQL Server};
SERVER=ps-sql; database=test; trusted_connection=yes’)
sql = ‘’’
select * from temp
‘’’
df = pd.read_sql(sql, conn)
######################################################33
#######################Feed SQL into python######################3

import pandas as pd
longform = pd.DataFrame(columns=[‘assets__c’, ‘id’])
for idx, songs, name in df.itertuples():
name_words = (i.lower() for i in name.split())
longform = longform.append(
[{‘assets__c’: nw, ‘id’: songs} for nw in name_words],
ignore_index=True
)
longform[‘refreshdate_unpack’] = pd.to_datetime(‘today’)

longform
##############Write longform into a sql table######################

any inputs?

Hi,

There are a couple of Snaps you can use:
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1439321/Script
or
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/615383126/Remote+Python+Script

Though the Remote Python Script takes a bit more doing to get it going.

BR,
Dimitri

1 Like