joellubi commented on issue #2171: URL: https://github.com/apache/arrow-adbc/issues/2171#issuecomment-2363554391
> The test works, but I think only because the URI already has the database in it which sets the context. This is true. I believe this is a Snowflake quirk where a default database must be set in order to use unqualified schema names (see [USE DATABASE](https://docs.snowflake.com/en/sql-reference/sql/use-database)). This makes sense in most cases, but doesn't seem like it should be necessary for special schemas like `information_schema`. The only ways I have been able to get this to work have been to use a default database for the session, or to qualify the schema in the query (e.g. `database_name.information_schema`). Snowflake requires the database name in both cases. Was this working before? Prior to this change we used `SHOW TERSE DATABASES` to get the catalogs, which may not have required a database to be set for the session. I think this can present issues for users aiming to use `GetObjects` to discover the databases available before connecting to one. Would it make sense to allow users with no database currently set for their session to issue `GetObjects(depth=Catalog)` and get the result of `SHOW TERSE DATABASES` to help bridge this gap before they can add a database to the session? -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
