SQL 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.

Ambiguous Name

When you get an "Ambiguous Name" error, this is likely due to one of these two issues:

  1. 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"
  2. 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.

YAML Errors

Check that you have two spaces per indentation.

Do not use tabs if you are editing the recipe in an external editor.