KNOWLEDGE BASE

Received Error in Tableau working with PostgreSQL UUIDs


Published: 25 Mar 2022
Last Modified Date: 11 May 2022

Issue

When a user connects to PostgreSQL and update the data from Tableau Desktop, the following error occurs:
 
ERROR: operator does not exist: text=uuid
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
 Position: xxxx

Error Code: 975DF5A2

or
 
ERROR: function min(uuid) does not exist 
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: xxxx

Error Code: 975DF5A2

Environment

  • Tableau Desktop 2021.4.4
  • PostgreSQL

Resolution

Option 1

Hide the columns or replace tables with custom SQL that do not include these columns.
 

Option 2

Use custom SQL to explicitly cast that column to text. If there are multiple tables joined, make sure casting is presented on all the tables.

Cause

Two issues are involved:
  1. A PostgreSQL column of type uuid and it is not well supported by Tableau. 
  2. The casting is not presented on all tables when querying the database.
Did this article resolve the issue?