How to connect Trino (Fabric) to OneLake (Fabric) with Parquet files

I have Parquet files stored in Microsoft Fabric OneLake. I’m trying to connect from Trino (running in VM) so I can query those files, but haven’t found a working configuration yet.

Ultimately, I want to be able to query from my application using Trino like this:

SHOW TABLES FROM delta.fabric_lakehouse;
SELECT * FROM delta.fabric_lakehouse.sales_data LIMIT 10;

Connection Approaches Attempted

Connection Approaches Attempted

1. Direct SQL Server Connector (AAD Password)
   • Method: Trino SQL Server connector with AAD username/password.
   • Status: Failed
   • Reason: Fabric endpoint does not allow username-password auth from external tools like Trino due to MSAL token requirements.
2. SSMS Connection
   • Method: AAD - Universal with MFA (via SSMS)
   • Status: Successful manually
   • Limitation: Trino has no GUI/browser-based auth support.
3. AAD Token-based Authentication
   • Observation: Works in theory for Trino → Fabric SQL Endpoint, but is difficult to implement in practice due to token refresh and library limitations.
4. Delta Lake Connector via ABFS

Requires Service Principal (SPN) auth. This is the path we are trying now.