Set default session parameters at the account level

[wesleyhillyext]

Snowflake supports setting session parameters defaults at the account level. For example:

ALTER ACCOUNT SET ABORT_DETACHED_QUERY = TRUE;
ALTER ACCOUNT SET TIMEZONE = 'UTC';
SHOW PARAMETERS IN ACCOUNT;

I've tried to use the new snowflake_account_parameter or snowflake_object_parameter resources to specify these for all our accounts in terraform, but so far I haven't managed to get it to work.

Using snowflake_account_parameter just complains that these settings aren't valid account parameters:

resource snowflake_account_parameter timezone {
  key = "TIMEZONE"
  value = "UTC"
}

Complains that TIMEZONE is not a valid key (I shortened the message):

Error: expected key to be one of [MULTI_STATEMENT_COUNT ...], got TIMEZONE

Okay, so I figured that this is what the on_account parameter to snowflake_object_parameter is meant for. This:

resource snowflake_object_parameter timezone {
  on_account = true
  key = "TIMEZONE"
  value = "UTC"
}

Gives this error with a set of expected keys which doesn't match any pattern I can think of:

Error: expected key to be one of [STATEMENT_TIMEOUT_IN_SECONDS ...], got TIMEZONE

Trying the following makes it complain that there's no such thing as a session parameter, but parameters.go lists the TIMEZONE parameter as type ParameterType{ParameterTypeSession}:

resource snowflake_object_parameter timezone {
  object_type = "SESSION"
  object_identifier {
    name = ""
  }
  on_account = true
  key = "TIMEZONE"
  value = "UTC"
}

Trying to call it a user parameter (as all session parameters can be set at the user level) just gets me back to it complaining that TIMEZONE is not a valid key:

resource snowflake_object_parameter timezone {
  object_type = "USER"
  object_identifier {
    name = ""
  }
  on_account = true
  key = "TIMEZONE"
  value = "UTC"
}

Is there a way that setting session parameter defaults at the account level is meant to work? If not, please consider that a feature request. I don't have a strong opinion on whether its added to snowflake_account_parameter or snowflake_object_parameter { on_account = true }, as the distinction between the two isn't clear to me and seems kind of arbitrary.