KNOWLEDGE BASE

Error "Basic authentication or X-Trino-User must be sent" When Connecting to Trino from Tableau Cloud


Published: 12 May 2022
Last Modified Date: 08 Jun 2022

Issue

When connecting to Trino (formerly known as PrestoSQL), the following error may occur:

Bad Connection: Tableau could not connect to the data source.
Error Code: FAB9A2C5
Authentication failed: Basic authentication or X-Trino-User must be sent
Unable to connect to the Presto server "
<server name>". Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Cloud
  • Presto

Resolution

Configure the Trino server to support connections using the Simba Presto ODBC Driver (64-bit) version 1.1 by adding a configuration property:
protocol.v1.alternate-header-name=Presto

Cause

Tableau Cloud currently uses the Simba Presto ODBC Driver (64-bit) version 1.1 with the Presto connector. This driver expects the HTTP client protocol headers to start with X-Presto-.

Additional Information

For more information about the protocol.v1.alternate-header-name configuration property, see this Trino document.
Did this article resolve the issue?