You can change the default schema (= what is used if no schema is specified in the query) here:
However, if you use the schema extensively in your data model to structure the model, you should always use the schema in the query. Working with fully qualified object names is simply best practice and avoids misunderstandings. It seems better not to rely on such things like a default schema because it can changed (or diff from server to server). This becomes even more important when the same object names exist in different schemas.
jm2c
Andreas
SQL DATA LENS release 3.15 is out! Download here for free
The new AI features available in the world are great for a small development company. It allows me to focus on integrating new features into SQL DATA LENS and let an AI bot generate some promotional videos.
What do you think about this:
The last element is the namespace not the schema, please see here: Using the JDBC Driver | Using Java with InterSystems Software | InterSystems IRIS Data Platform 2024.1
jdbc:Cache://<host>:<port>/<namespace>
Andreas