SSC-EWI-0049

A Global Temporary Table is being referenced.

This EWI is deprecated, please refer to SSC-FDM-0023 documentation.

Severity

Medium

Description

Snowconvert transforms Global Temporary tables into regular Create Table. References to these tables may behave different than expected.

Code example

Input

create global temporary table t1 
    (col1 varchar); 
create view view1 as 
    select col1 from t1;

Output

--** SSC-FDM-0009 - GLOBAL TEMPORARY TABLE FUNCTIONALITY NOT SUPPORTED. **
CREATE OR REPLACE TABLE t1
    (col1 varchar)
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
;

CREATE OR REPLACE VIEW view1
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
AS
select col1 from
    !!!RESOLVE EWI!!! /*** SSC-EWI-0049 - A Global Temporary Table is being referenced ***/!!!
    t1;

Related Issues

• SSC-FDM-0009: GLOBAL TEMPORARY TABLE functionality not supported.

Recommendations

• If you need more support, you can email us at [email protected]