error: at least one column must be specified for the table.

[DB_795688_DB_44]

error: at least one column must be specified for the table.

[etsyal1e2r3]

Can you post the code thst caused the error and a description of what youre trying to do?

[DB_795688_DB_44]

Sorry for not posting the code. We have written pysql code step wise (like stored proc). It has all the Source, target and temporary tables with join conditions. We are executing the notebook via workflow jobs with different years passing as parameters. The error is coming randomly. If we are re-running the failure job with same year, it is successfully completing.

[etsyal1e2r3]

Yeah no way of knowing without looking at the code but i use dataframes until i have to do specific joins/upserts. It sounds like theres an extra one that doesnt exist yet therefore no columns are being grabbed/given. Make sure everything youre passing is s valid table. Im guessing youre dynamically referring to columns in all the tables to update them each time. Maybe break it up so you can print each step and check whats being passed esch time.

[Anonymous]

Hi @anand R​ 

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you. 

Cheers!