Insert Statement

SQL statement that adds new rows to a table.

See Insert statement

In Teradata, there is an alternateINSERTsyntax that assigns the value for each table column inline. This alternate structure requires a special transformation to be supported in Snowflake. The inline assignment of the values is separated and placed inside the VALUES(...) part of the Snowflake INSERT INTO statement.

Teradata

INSERT INTO appDB.logTable (
    process_name = 'S2F_BOOKS_LOAD_NEW'
    , session_id = 105678989 
    , message_txt = '' 
    , message_ts = '2019-07-23 00:00:00'
    , Insert_dt = CAST((CURRENT_TIMESTAMP(0)) AS DATE FORMAT 'YYYY-MM-DD'));

Snowflake

INSERT INTO appDB.sfSchema.logTable (
    process_name
    , session_id
    , message_txt
    , message_ts
    , Insert_dt)
VALUES (
    'S2F_BOOKS_LOAD_NEW'
    , 105678989
    , ''
    , '2019-07-23 00:00:00'
    , TO_DATE((CURRENT_TIMESTAMP(0))) /*** MSC-WARNING - MSCEWI2025 - OUTPUT FORMAT 'YYYY-MM-DD' NOT SUPPORTED. ***/);

Related EWIs

No related EWIs.

PreviousDelete StatementNextSelect Statement

Last updated