SNOW-781552: Add getter and setter methods to Session class

[sfc-gh-jfreeberg]

Add the following methods to the Session class:

• .getCurrentAccount() -> Optional<String>
• .getCurrentWarehouse() -> Optional<String>
• .getCurrentRole() -> Optional<String>

These methods can be used to change the db/role/warehouse at different stages of a job.

• .setDatabase(database: string) -> void
• .setRole(role: string) -> void
• .setSchema(schema: string) -> void
• .setWarehouse(warehouse: string) -> void

Each should return the string of the corresponding key. For reference, here is the implementation in the Python SDK: https://github.com/snowflakedb/snowpark-python/blob/main/src/snowflake/snowpark/session.py

[sbouhaddi]

Can i have a look at this one too?

[sbouhaddi]

You can assign this one also to me.
Thank you

[sbouhaddi]

Hello ,
Do you mean something like this ?

Optional getCurrentAccount() {
var account = session.conn().getParameterValue("account", false, Option.empty());
return Optional.of(account);
}