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