jaceksan opened a new issue #2324: URL: https://github.com/apache/drill/issues/2324
**Is your feature request related to a problem? Please describe.** I specify JDBC URL like this: `jdbc:snowflake://<account>.snowflakecomputing.com:443?warehouse=<warehouse>&db=<db>&CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX=true` Despite I use CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX=true , INFORMATION_SCHEMA.SCHEMATA contains schemata from all warehouses and databases (the user has access to everywhere). In our platform, when I use this parameter and I call e.g. dbMetadata.getTables() , it collects only tables from corresponding warehouse and database. Querying all warehouses can be very expensive causing SELECT from Drill INFORMATION_SCHEMA takes ages. **Describe the solution you'd like** Parameter CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX is properly propagated to the connection from Drill to Snowflake, only objects from warehouse/database specified in the JDBC URL are populated into Drill INFORMATION_SCHEMA. **Describe alternatives you've considered** The only workaround solution is to limit privileges of DB user (what warehouses/databases he can see). This is not a valid workaround in our case (testing user has read access to huge number of testing warehouses/databases). -- 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]
