i have the JDBC connection set and the Database URI includes a default DB, SCHEMA and WAREHOUSE. when selecting CREATE BASE VIEW, i see other schemas. If i select a table from a schema or db other then the values provided in the JDBC connection string, i get an error:
<object name> [JDBC WRAPPER] [ERROR]
<object name>#0 [JDBC ROUTE] [ERROR] Received exception with message 'No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' command.'
Based on this error, I have two questions:
1) Even though I can see all schemas and objects via this connection, am I limited to only creating objects within that db/schema?
2) Can i change the db/schema dynamically or does each db/schema combination require a seperate JDBC connection for Snowflake?