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
Last Modified Date: 07 Apr 2023
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.Additional Information
More information on the "Column reference "<name>" is ambiguous error can be found below:- Identifier Qualifiers at MySQL
- 8 Tips Absolute Beginners can Use to Fix SQL Queries at Vertabelo Academy
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials