Ability to set global account parameters

[JPScutt]

Terraform CLI and Provider Versions

Terraform version 1.7.4
Snowflake provider: 0.87.2

Use Cases or Problem Statement

I want to setup database replication between 2 Snowflake accounts but I can't currently set the ENABLE_ACCOUNT_DATABASE_REPLICATION property via a TF resource or other global account params.

SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('<account_identifier>',
'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true');

Would be great to do this and not have to use the unsafe execute resource.

Proposal

Add new resources to enable the setting and unsetting of global account parameters.

How much impact is this issue causing?

Medium

Additional Information

No response

[sfc-gh-jcieslak]

Hey @JPScutt. Thanks for reaching out to us.

We are in the process of redesigning the existing resources and adding the missing functionalities as part of https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/ROADMAP.md#supporting-all-snowflake-ga-features). System functions are one of the things on our list to discuss/add to the provider.

[JPScutt]

@sfc-gh-jcieslak thanks for the response.

Will snowflake_unsafe_execute resource remaining until the redesign and missing functionality work is completed? Just so I know it is safe to proceed with that in the interim.

[sfc-gh-jcieslak]

Correct. For now, use snowflake_unsafe_execute.