SSC-EWI-SY0001
Unsupported default value in Snowflake.
Severity
High
Description
Snowflake does not support the use of the following default values.
CURRENT REMOVE USER
LAST USER
CURRENT PUBLISHER
Code Examples
Input Code:
create table t1
(
col1 varchar default current remote user,
col2 varchar default last user,
col3 varchar default current publisher
);
Output Code:
CREATE OR REPLACE TABLE t1 (
col1 VARCHAR default
!!!RESOLVE EWI!!! /*** SSC-EWI-SY0001 - UNSUPPORTED DEFAULT VALUE CURRENT REMOTE USER IN SNOWFLAKE ***/!!!
current remote user,
col2 VARCHAR default
!!!RESOLVE EWI!!! /*** SSC-EWI-SY0001 - UNSUPPORTED DEFAULT VALUE LAST USER IN SNOWFLAKE ***/!!!
last user,
col3 VARCHAR default
!!!RESOLVE EWI!!! /*** SSC-EWI-SY0001 - UNSUPPORTED DEFAULT VALUE CURRENT PUBLISHER IN SNOWFLAKE ***/!!!
current publisher
)
;
Recommendations
If you need more support, you can email us at [email protected]
Last updated