KNOWLEDGE BASE

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


Published: 11 Apr 2015
Last Modified Date: 07 Nov 2019

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

The error occurs within the data source and is not related to Tableau. 

 
Did this article resolve the issue?