Trino connection request is failing with status code 401 while fetching schema and running queries

[sakethmukkanti]

What happens?

I am getting below error when trying to fetch schema and run Malloy queries for an Iceberg table using Trino connection -

Error(s) compiling model: FILE: file:///my_path/trino_queries.malloy line 1: Could not fetch schema for table Catalog.Schema.Table Request failed with status code 401 | source: my_source is trino.table('Catalog.Schema.Table') extend { | ^

To Reproduce

These are the steps I followed to run Malloy queries -

• Installed Malloy VS Code extension in my local VS Code
• Opened VS Code from terminal after setting "export NODE_TLS_REJECT_UNAUTHORIZED=0" (to avoid unable to get local issuer certificate)
• Created a new connection in Edit Connections tab with the connection type as Trino and provided all the details.
• Able to test the connection and getting Success message
• Created a Malloy source and clicked Schema button on top and I am getting below error

OS:

macOs

Malloy Client:

local VSCode

Malloy Client Version:

VSCode Extension 0.2.1757277942

Database Connection:

Trino

[sakethmukkanti]

Hi @kylenesbit ,

I have identified the bug which is causing this error.

• When we are creating a connection for Trino in trino_presto_connection.ts, we are passing connectionConfig as parameter instead of config.

• We are fetching password from Keystore and storing it in config, hence config should be passed to connection and that connection is getting passed to runtime to fetch schema.

• Since our connectionConfig doesn't have the actual password it is failing with 401 error.

• I have changed extension code in my local by passing config as parameter while creating the Trino connection and tested this in Debug: Start Debugging mode and I was able to fetch the schema for my Malloy source successfully.

Please let me know if I missed something. Also can I assign this issue to myself so that this could be a good first issue for me to contribute.