Error: error creating resource monitor RM_ETL err = 090263 (42601): The specified Start time has already passed.

[toni-moreno]

Provider Version
0.61.0

Terraform Version
1.4.4

Describe the bug

 Error: error creating resource monitor RM_ETL err = 090263 (42601): The specified Start time has already passed.
│ 
│   with snowflake_resource_monitor.RM["RM_ETL"],
│   on 001_resource_monitors.tf line 5, in resource "snowflake_resource_monitor" "RM":
│    5: resource "snowflake_resource_monitor" "RM" {

I can not create a resource monitor with custom start/end

Expected behavior

As I can do with the snowflake ui , I would like to create RM with start timestamp in the past.

Code samples and commands

  "RM_ETL" = {
    quota           = 1000
    frequency       = "NEVER"
    start_timestamp = "2023-03-29 12:00"
    end_timestamp   = "2023-11-01 12:00"
    notify_triggers = [75, 100]
    warehouses      = ["MYETL"]
  }

[sfc-gh-jcieslak]

Hey 👋
That's a Snowflake error, not the provider one. It basically means that the resource monitor cannot be created with the start_timestamp older than the current date. Please, close the issue if that's the case. An important note is that I'm currently working on the resource monitor as part of preparing GA objects for V1, so a lot may change, and the improvements are coming.

[sfc-gh-jcieslak]

Closing due to long inactivity, the error was from Snowflake and in the newer versions of the provider the resource monitor was refactored and should handle this case better.