https://pulumi.com logo
Title
s

salmon-motherboard-78006

10/12/2022, 7:41 PM
Hi, Trying to create a Snowflake table with clustering and getting an error:
Table(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?