Resolving Batch Recipe Errors
Finding SQL syntax errors in a long SQL statement
Do a find (CTRL+F) for the string "^^^" and you will find the exact location of the error.
When you get an "Ambiguous Name" error, this is likely due to one of these two issues:
- The field is available in two joined table and you have not specified which table to reference the field from.
Change "firstName" to "table1.firstName"
- The field named is specified in the schema has a different case than the field returned from the source.
If the schema has "lead_id" and the source data returns "lead_ID", you will get an ambiguous error.
Check that you have two spaces per indentation.
Do not use tabs if you are editing the recipe in an external editor.