Snowconvert: Sybase IQ Issues¶
SSC-EWI-SY0001¶
Severity¶
High
Description¶
Snowflake does not allow the following default values to be used.
Currently logged-in user
Most recent user
Current publishing user
Code Examples¶
Input Code:¶
create table t1
(
col1 varchar default current remote user,
col2 varchar default last user,
col3 varchar default current publisher
);
Generated 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
)
;
Best Practices¶
For additional support, please contact us at snowconvert-support@snowflake.com
SSC-EWI-SY0002¶
Severity¶
High
Description¶
Snowflake does not support the syntax used for remote tables in Sybase IQ.
Code Examples¶
Input Code:¶
CREATE TABLE remote_data(
remote_id INT
)
AT 'remote_server;remote_db;owner;remote_object';
Generated Code:¶
CREATE OR REPLACE TABLE remote_data_semicolon (
remote_id INT
)
!!!RESOLVE EWI!!! /*** SSC-EWI-SY0002 - UNSUPPORTED REMOTE TABLE SYNTAX ***/!!!
AT 'remote_server;remote_db;owner;remote_object'
;
Best Practices¶
For additional support, please contact us at snowconvert-support@snowflake.com
SSC-EWI-SY0003¶
Severity¶
High
Description¶
The IQ UNIQUE constraint, which estimates the number of unique values in a column, has no equivalent constraint in Snowflake.
Code Examples¶
Input Code:¶
CREATE TABLE T1 (
DATA VARCHAR IQ UNIQUE(10)
)
;
Generated Code:¶
CREATE OR REPLACE TABLE T1 (
DATA VARCHAR
!!!RESOLVE EWI!!! /*** SSC-EWI-SY0003 - UNSUPPORTED IQ UNIQUE CONSTRAINT ***/!!!
IQ UNIQUE(10)
);
Best Practices¶
For additional support, please contact us at snowconvert-support@snowflake.com