SSC-FDM-0023

A Global Temporary Table is being referenced.

Severity

Medium

Description

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

Code example

Input

IN -> Oracle_01.sql
create global temporary table t1 
    (col1 varchar); 
create view view1 as 
    select col1 from t1;

Output

OUT -> Oracle_01.sql
--** 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
    --** SSC-FDM-0023 - A Global Temporary Table is being referenced **
    t1;
  • SSC-FDM-0009: GLOBAL TEMPORARY TABLE functionality not supported.

Recommendations

Last updated