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.