Add default timestamp function as a default value using terraform chanzuckerberg snowflake provider

Viewed 176

I am trying to create a table and for the column I want to give the default value as current timestamp. What am I doing wrong here? Ref - https://registry.terraform.io/providers/chanzuckerberg/snowflake/latest/docs/resources/table

resource "snowflake_table" "snow_events_table" {
  database        = "SNOW"
  schema          = "PUBLIC"
  name            = "SNOW_EVENTS"
  comment         = "Events from S3 are transformed into this table"
  cluster_by      = ["org_id"]
  change_tracking = false

  column {
    name     = "_date_created"
    type     = "TIMESTAMP_NTZ(9)"
    nullable = false

    default {
      expression = "CURRENT_TIMESTAMP()"
    }
  }
}

Error is

Error: Unsupported block type │  │   on ../../modules/snowplow-s3-storage/tables.tf line 21, in resource "snowflake_table" "snow_events_table": │   21:     default { │  │ Blocks of type "default" are not expected here.
0 Answers
Related