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

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-.