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######################
