salmon-motherboard-78006
10/12/2022, 7:41 PMTable(resource_name=name,
name=name,
database=schema.database,
schema=schema.name,
comment=comment,
cluster_bies=[to_date("dw_created_at)"],
data_retention_days=schema.data_retention_days,
change_tracking=False,
columns=[
snowflake.TableColumnArgs(
name="data",
type="VARIANT",
nullable=False,
),
snowflake.TableColumnArgs(
name="dw_created_at",
type="TIMESTAMP_LTZ",
nullable=False,
default=TableColumnDefaultArgs(expression="current_timestamp()")
),
],
opts=ResourceOptions(provider=provider))
error:
000904 (42000): SQL compilation error: error line 1 at position 65
invalid identifier 'DW_CREATED_AT'
This is what I’m seeing in query history:
ALTER TABLE "DEV_DB"."STAGING"."gu" CLUSTER BY LINEAR(dw_created_at)
Anybody seen this error?