search

TylerHillery / harlequin-adbc

An ADBC adapter for Harlequin
MIT License
2 stars 0 forks source link

`Data Catalog` emtpy #7

Open paw-lu opened 1 month ago

paw-lu commented 1 month ago

First, awesome work here, really appreciate you sharing this.

When connecting to snowflake via:


$ harlequin company.region.snowflakecomputing.com:443/database?account=account&authenticator=externalbrowser

i can execute queries as expected, but the Data Catalog tab on the left remains empty. This expected?

SCR-20240815-jirb
paw-lu commented 1 month ago

Actually now looking at the README I bet these are related

  • Snowflake adbc driver seems to be the only driver that returns the xdbc_data_type from adbc_get_objects()
  • Snowflake adbc driver has a bug with adbc_get_table_schema() that returns adbc_driver_manager.OperationalError: IO: sql: expected 12 destination arguments in Scan, not 11
TylerHillery commented 1 month ago

Thanks for raising this issue, those issues you pointed out shouldn't effect the data catalog. Let me try to reproduce the error on my end and see what's going on.

TylerHillery commented 4 weeks ago

@paw-lu do you know if authenticator=externalbrowser requires to have SSO on your snowflake account? I am trying to use the same URI format as the one you provided but for me nothing happens and the data catalog is in a continuously loading state. The URI format I tested with is was USERNAME:PASSWORD@org-account.snowflakecomputing.com so I am wondering if there is something going on with this auth method that's causing things to break.

paw-lu commented 2 weeks ago

sorry missed this comment!

i don't know if it's required, but yes, I am using SSO here (ie i don't input a username and password in the browser)