SSC-EWI-0049

A Global Temporary Table is being referenced.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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]