Error "ERROR: column reference "..." is ambiguous" Refreshing Custom SQL Data Extract
Published: 11 Apr 2015 Last Modified Date: 07 Nov 2019
When trying to refresh a data extract containing custom SQL, the following error might occur:
ERROR: column reference "<field name>" is ambiguous; Error while executing the query
Tableau Data Extract
Verify that the SQL Query completes successfully when run directly against the database. If the query does not complete successfully, work with your database administrator to address issues in the query.
The error occurs within the data source and is not related to Tableau.
More information on the "Column reference "<name>" is ambiguous error can be found below: