Support for OAuth2Authentication for Trino magic doesn't work

CybercentreCanada / jupyterlab-sql-editor

A JupyterLab extension providing, SQL formatter, auto-completion, syntax highlighting, Spark SQL and Trino

BSD 3-Clause "New" or "Revised" License

83 stars 13 forks source link

Support for OAuth2Authentication for Trino magic doesn't work #82

Open IceS2 opened 1 year ago

IceS2 commented 1 year ago

Hello folks!

I'm testing the extension a little bit. For now I'm just trying to connect to a Trino database through OAuth2Authentication without testing the other features (autocompletion/syntax highlighting). When I try to configure that auth I get a pickle error:

%config Trino.auth=trino.auth.OAuth2Authentication() -> ERROR:root:cannot pickle '_thread.lock' object

Any ideas on how I could deal with it?

govindhi commented 3 months ago

Any update here? I am also seeing the same issue.

IceS2 commented 3 months ago

Since I couldn't solve it and had no answer here I ended up not using this repository, but taking it as inspiration to develop what we needed from ipython-sql directly by creating our own magic command.