KNOWLEDGE BASE

Presto Tables Cannot be Pulled Into Tableau Desktop


Published: 11 Feb 2022
Last Modified Date: 19 Feb 2022

Issue

When pulling a Presto table after connecting to PrestoSQL, it fails with the error FAB9A2C5 (Error executing query).

Environment

  • Tableau Desktop 2021.4.2
  • PrestoSQL 343

Resolution

Using SimbaPresto ODBC instead of JDBC
  1. Remove presto-jdbc-0.262.jar from C:/Program Files/Tableau/Drivers/

  2. Install the SimbaPresto ODBC ( SimbaPresto1.1-64-bit.msi). Contact Tableau Support to get the driver.

  3. Restart Tableau Desktop and make use of ODBC Driver.

Cause

The incorrect JDBC driver is used for PrestoSQL 343.
Did this article resolve the issue?