Error "ERROR: column reference "..." is ambiguous" Refreshing Custom SQL Data Extract
Published: 11 Apr 2015 Last Modified Date: 30 Aug 2017
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.