SPRKSPSQL1005

TBLPROPERTIES is not supported in Snowflake

Category

Conversion error

Description

This error message appears when an Alter Table or an Alter View tries to SET / UNSET Table Properties using TBLPROPERTIES. The SMA adds an EWI in the output code above the statement.

Input Code

ALTER TABLE DUMMY_TABLE
SET TBLPROPERTIES ('IsNested'= 'True');

Output Code

---- Alter Table comment 0
----EWI: SPRKSPSQL1005 => TblProperty is not fully supported. ALTER TABLE DUMMY_TABLE SET TBLPROPERTIES ('IsNested' = 'True');
--ALTER TABLE DUMMY_TABLE
--SET TBLPROPERTIES ('IsNested'= 'True');

SMA adapts the statement when the property "comment" is included into the TBLPROPERTIES

Input Code (With Comment)

ALTER TABLE DUMMY SET TBLPROPERTIES ("comment" = "test","id" = "id");

Output Code (With Comment)

--EWI: SPRKSPSQL1005 => TblProperty is not fully supported. ALTER TABLE DUMMY SET TBLPROPERTIES ("comment" = "test", "id" = "id");
ALTER TABLE DUMMY
SET COMMENT = 'test';

Recommendation

• For more support, email us at [e-mail]. If you have a support contract with Snowflake, reach out to your sales engineer, who can direct your support needs.