KNOWLEDGE BASE

Error "ERROR: column reference "..." is ambiguous" Refreshing Custom SQL Data Extract


Published: 11 Apr 2015
Last Modified Date: 31 Aug 2016

Issue

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 

Environment

  • Tableau Professional
  • Tableau Data Extract
  • Custom SQL 

Resolution

Verify that the SQL Query completes successfully when run directly against the database. If it does not, refer user to database administrator to address the query error.

Cause

Error in SQL query. 

 
Did this article resolve the issue?