Error: Invalid provider configuration when moving from snowflake_<object>_grant to snowflake_grant_privileges_to_role

[florencewambui]

After upgrading Snowflake Provider version to ~> 0.68.2, we get deprecation warnings for schema, warehouse and view objects. An example of warehouse deprecation warning:

Warning: Deprecated Resource
with snowflake_warehouse_grant.transform_wh_grant
on warehouses.tf line 54, in resource "snowflake_warehouse_grant" "transform_wh_grant":
resource "snowflake_warehouse_grant" "transform_wh_grant" {
This resource is deprecated and will be removed in a future major version release. Please use snowflake_grant_privileges_to_role instead

In an effort to move to snowflake_grant_privileges_to_role , I updated warehouses.tf from:

#old method to grant privileges to warehouse
resource "snowflake_warehouse_grant" "transform_wh_grant" {
  provider          = snowflake.security_admin
  warehouse_name    = snowflake_warehouse.transform_wh.name
  privilege         = "USAGE"
  roles             = [snowflake_role.data_engineer_role.name]
  with_grant_option = false
}

to

#new method to grant privileges to warehouse
resource "snowflake_grant_privileges_to_role" "transform_wh_data_engineer_grant" {
  privileges = ["USAGE"]
  role_name  = snowflake_role.data_engineer_role.name
  on_account_object {
    object_type = "WAREHOUSE"
    object_name = snowflake_warehouse.transform_wh.name
  }
}

Upon running Terraform Plan, I get these errors:

Error: could not build dsn for snowflake connection err = Account and User must be set in provider config, ~/.snowflake/config, or as an environment variable.
with provider["registry.terraform.io/snowflake-labs/snowflake"]
on <empty> line 0:
Error: Invalid provider configuration
Provider "registry.terraform.io/snowflake-labs/snowflake" requires explicit configuration. Add a provider block to the root module and configure the provider's required arguments as described in the provider documentation.

Our current provider.tf is set up as follows:terraform {

  required_providers {
    snowflake = {
      source  = "Snowflake-Labs/snowflake"
      version = "~> 0.68.2"
    }
    random = {
      source  = "hashicorp/random"
      version = "3.3.2"
    }
  }

  cloud {
    organization = "org_name"

    workspaces {
      name = "org_workspace"
    }
  }
}


provider "snowflake" {
  alias       = "sys_admin"
  role        = "SYSADMIN"
  account     = var.account
  region      = var.region
  username    = var.username
  private_key = var.private_key
}

provider "snowflake" {
  alias       = "security_admin"
  role        = "SECURITYADMIN"
  account     = var.account
  region      = var.region
  username    = var.username
  private_key = var.private_key
}

provider "snowflake" {
  alias       = "account_admin"
  role        = "ACCOUNTADMIN"
  account     = var.account
  region      = var.region
  username    = var.username
  private_key = var.private_key
}

We have variables account, region, username and private_key in Terraform Cloud workspace variables. We have variables.tf set up as:

variable "account" {
  description = "snowflake account"
  type        = string
  sensitive   = true
}

variable "region" {
  description = "snowflake region"
  type        = string
}

variable "username" {
  description = "snowflake username"
  type        = string
}

variable "private_key" {
  description = "snowflake terraform user private key"
  type        = string
  sensitive   = true
}

How do I resolve the aforementioned error?
Thank you.