Support setting session parameters in the provider configuration

[cskinfill]

Is your feature request related to a problem? Please describe.

Setting session parameters that would apply to all the requests made by the provider. These session parameters would be set at the provider configuration level, and could be overwritten by session parameters set on a specific resource (like snowflake_task).

Describe the solution you'd like

In the provider configuration, a map that would be applied to the connection string as session parameters.

Describe alternatives you've considered

I'm not aware of a way to do this using the existing provider.

Additional context

I'm especially interested in setting the TIMEZONE session parameter.

[mddataminr]

I would love to be able to set the session database. This should help with issues like:
Pipe: #533
Stage: #994

[sfc-gh-asawicki]

Hey @cskinfill, @mddataminr .

Setting session parameters is allowed in the provider's configuration: https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs#params-1, please let us know if this works for you.

[cskinfill]

@sfc-gh-asawicki thanks for getting back about this issue. I'm not currently working with the snowflake terraform provider anymore, so I won't be able to provide much feedback.

[sfc-gh-asawicki]

Hey @cskinfill. Thanks.

I will close this issue then.