I am defining a pipeline in the data factory, I had some errors that I correct. The first activity is calling USQL script to do some aggregation, I changed the script plenty of time but the error is still:
[{"errorId":"E_CSC_USER_SYNTAXERROR","severity":"Error","component":"CSC","source":"USER","message":"syntax error. Final statement did not end with a semicolon","details":"at token 'usql', line 4\r\nnear the ###:\r\n**************\r\nCLARE @lineitemsfile string = \"/datalakerepo/input/2016/01/01lineitems.txt\";\nDECLARE @ordersfile string = \"/datalakerepo/input/2016/01/01orders.txt\";\nsales.usql ### \n","description":"Invalid syntax found in the script.","resolution":"Correct the script syntax, using expected token(s) as a guide.","helpLink":"","filePath":"","lineNumber":4,"startOffset":228,"endOffset":232}].
seem like not all USQL script is read from the data factory, so I thought that maybe the "rerun in upstream in the pipeline" has something to do with this, like clear cache from the previous script.
Does anyone know what "rerun in upstream in the pipeline" does?