UndefinedColumn - Column Does Not Exist

UndefinedColumn - Column Does Not Exist is a type of SQL statement error. It indicates that the database cannot find the specified column. This can occur if the underlying table has changed column names.

Example of Column Does Not Exist

Solution

Verify that the columns names are valid and can be found in the table.

1. Check if there are any unintended column names in the input fields. For example, columns names in the Order by or Where condition will also cause the action to fail.
2. Check with your database administrator of the columns name exists.
3. If you are using datapill from a previous step, refresh your recipe to get the latest schema from your connections.