Connection to snowflake with adbc - case issue with model generated from valid cube semantic model #57
Description
Hello,
There is some progress in the connection to snowflake but I still can't run my queries using the query() method.
I installed latest adbc drivers using dbc as mentioned in your example.
I do not see anymore the catalog error I had in Issue 15
But it is still unstable:
- usage of adbc drivers is not documented (how should I pass the connection parameters to the SemanticLayer(connection=...) parameter? What is the url format to tell Sidemantic to use that driver? As my sidemantic model yaml is generated from a cube model, it doesn't have the connection parameters inside it (and therefore, I would like to use the python API to define the connection)
- when referring to a table in another catalog/db available in the same connection, the query is generated for the default catalog/db
- when executing a query, it works with some models, but not all