SNOW-1471204: Ability to interpolate variables within config.toml

[kameshsampath]

Description

When the snow cli creates the config.toml it does not interpolate the variables within the attribute values except for ~.

e.g.

default_connection_name="cheatsheets"

[connections]
[connections.cheatsheets]
account = "account-id"
user = "kameshs"
warehouse = "COMPUTE_WH"
schema = "PUBLIC"
authenticator = "SNOWFLAKE_JWT"
private_key_path="$KEYS_DIR/.keys/rsa_key.p8"

The $KEYS_DIR never gets interpolated while reading the key path.

It will be nice to add variable interpolation support for all attribute values with in the config.toml.

Context

No response

[sfc-gh-pczajka]

Hi @kameshsampath!
Parsing config.toml happens on snowflake-connector-python side - it looks like your issue falls under their scope
https://github.com/snowflakedb/snowflake-connector-python

[kameshsampath]

@sfc-gh-pczajka opened a new issue snowflakedb/snowflake-connector-python#1971, please feel free to close this if needed.