SYSTEM_DEFINED

Some parts in the output code are omitted for clarity reasons.

Non-relevant statement.

Notice that this statement is removed from the migration because it is a non-relevant syntax. It means that it is not required in Snowflake.

Description

Property in Teradata that can be after a CREATE statement in cases such as JOIN INDEX.

Sample Source Patterns

Notice that SYSTEM_DEFINED has been removed from the source code because it is a non-relevant syntax in Snowflake.

Teradata

IN -> Teradata_01.sql

CREATE SYSTEM_DEFINED JOIN INDEX MY_TESTS.MYPARTS_TJI004 ,FALLBACK ,CHECKSUM = DEFAULT, MAP = TD_MAP1 AS
CURRENT TRANSACTIONTIME 
SELECT
    MY_TESTS.myParts.ROWID,
    MY_TESTS.myParts.part_id,
    MY_TESTS.part_duration
FROM MY_TESTS.myParts
UNIQUE PRIMARY INDEX (part_id);

Snowflake

OUT -> Teradata_01.sql

--** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "MY_TESTS.myParts" **
CREATE MATERIALIZED VIEW MY_TESTS.MYPARTS_TJI004
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
AS
----** SSC-FDM-TD0025 - TEMPORAL FORMS ARE NOT SUPPORTED IN SNOWFLAKE **
--CURRENT TRANSACTIONTIME
                        SELECT
    MY_TESTS.myParts.ROWID,
    MY_TESTS.myParts.part_id,
    MY_TESTS.part_duration
FROM
    MY_TESTS.myParts;

Known Issues

No issues were found.

Related EWIs

1. SSC-FDM-0007: Element with missing dependencies.

2. SSC-FDM-TD0025: Teradata Database Temporal Table is not supported in Snowflake.