Insert Statement
SQL statement that adds new rows to a table.
See Insert statement
In Teradata, there is an alternateINSERT
syntax 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.
Last updated
Was this helpful?