[Feature]: Support connections.toml

[afeld]

Company Name

Colorado Behavioral Health Administration

Use Cases or Problem Statement

My team uses various Snowflake tools:

• The Terraform provider
• The Python Connector, directly and via schemachange and the Snowflake CLI
• The VSCode extension

At the moment, we need to configure each independently, and thus need to keep all those configurations in sync.

Category

category:provider_config

Object type(s)

No response

Proposal

It would be nice to have all the configuration across the various tools in one place. The Go Snowflake Driver seems to support connections.toml - see "Connection Config" in the package documentation. Looking for the Terraform provider to add support for / explain how to use that config file.

How much impact is this issue causing?

Low

Additional Information

Similar issue for schemachange: Snowflake-Labs/schemachange#281

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @afeld. Thanks for reaching out to us.

We have the uniforming of the configuration for all the tools on our radar. However, we won't address it before reaching the GA of the provider. There is no timeline I can share at the moment for the requested changes because it touches more tools than just this provider.

I would like to add that using the underlying driver's tool would be a breaking change to the current order of precedence of the configuration parameters (https://registry.terraform.io/providers/Snowflake-Labs/snowflake/1.0.0/docs#order-precedence), so we have to approach it carefully.

For now, we encourage you to use the provider's specific toml (https://registry.terraform.io/providers/Snowflake-Labs/snowflake/1.0.0/docs#order-precedence), which is really similar to the one used in the gosnowflake driver.