[Feature]: Add option to set user level parameter -> JDBC_QUERY_RESULT_FORMAT in Snowflake

[suren-hf]

Company Name

Hellofresh

Use Cases or Problem Statement

Problem Statement

The snowflake_user resource currently lacks support for managing user-specific parameter -> JDBC_QUERY_RESULT_FORMAT. This forces teams to manually execute SQL scripts like:

ALTER USER SRV_RTE_MANUFACTURING SET JDBC_QUERY_RESULT_FORMAT = 'JSON';  

This gap hinders automation and consistency.

Use Case

Extending the snowflake_user resource to support JDBC_QUERY_RESULT_FORMAT parameter would simplify IaC workflows by combining user creation and parameter management in a single resource.

Category

category:resource

Object type(s)

resource:user

Proposal

Enhance the snowflake_user resource to allow setting JDBC_QUERY_RESULT_FORMAT parameter directly.

For example:

resource "snowflake_user" "example" {  
  name                    = "SRV_RTE_MANUFACTURING" 
  // Other parameters
  jdbc_query_result_format = "JSON"  
} 

This improvement streamlines automation and aligns user management with Terraform's IaC principles.

How much impact is this issue causing?

Low

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @suren-hf. Thanks for reaching out to us.

While we were reworking the snowflake_user resource, we made the decision to support "only" the parameters documented in the official Snowflake docs (https://docs.snowflake.com/en/sql-reference/parameters). It's around 60 parameters. However, there are around as many parameters undocumented but visible in the SHOW PARAMETERS IN USER output (JDBC_QUERY_RESULT_FORMAT included). Before we add any of these missing parameters, we want to have clarity: why were they not included in the docs?
For now, you can use https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/execute to avoid manual work.
You can also file an issue to official Snowflake support that the parameter is not listed in the docs.