Migrating some on-premise SQL views to Databricks and struggling to find conversions for some functions. the main one is the string_agg function.string_agg(field_name, ', ')Anyone know how to convert that to Databricks SQL?Thanks in advance.
@Hemanth A try this code. import openpyxlwb = openpyxl.load_workbook('/dbfs/PATH/test.xlsx')ws = wb.activefor row in ws.iter_rows(): print([col.value for col in row])ws['A1']='A1'wb.save('/dbfs/PATH/test.xlsx')# Load its modified version and prin...
@Hemanth A go to the workspace you want data from, in warehouse tab you will find connectivity in that copy host name, http path and generate token for it, by this credentials you can access the data of this workspace in any other workspace.
