KNOWLEDGE BASE

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


Published: 11 Apr 2015
Last Modified Date: 30 Aug 2017

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 Desktop
  • Tableau Data Extract
  • Custom SQL 

Resolution

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. 

Cause

Error in SQL query. 

 
Did this article resolve the issue?