LOGGING ERRORS

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.

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

Statement to log errors when using statements as INSERT...SELECT. Please review the following documentation.

Sample Source Patterns

LOGGING ERRORS

In this example, notice that LOGGING ERRORS has been removed because it is not a relevant syntax. The syntax is not required in Snowflake.

Teradata

IN -> Teradata_01.sql

INSERT INTO MY_TABLE
SELECT *
FROM MY_SAMPLE
LOGGING ERRORS;

Snowflake

OUT -> Teradata_01.sql

INSERT INTO MY_TABLE SELECT
*
FROM
MY_SAMPLE;

LOGGING ALL ERRORS

In this example, notice that LOGGING ALL ERRORS has been removed because it is not a relevant syntax. The syntax is not required in Snowflake.

Teradata

IN -> Teradata_02.sql

INSERT INTO MY_TABLE
SELECT *
FROM MY_SAMPLE
LOGGING ALL ERRORS;

Snowflake

OUT -> Teradata_02.sql

INSERT INTO MY_TABLE SELECT
*
FROM
MY_SAMPLE;

LOGGING ERRORS WITH NO LIMIT

In this example, notice that LOGGING ERRORS WITH NO LIMIT has been removed because it is not a relevant syntax. The syntax is not required in Snowflake.

Teradata

IN -> Teradata_03.sql

INSERT INTO MY_TABLE
SELECT *
FROM MY_SAMPLE
LOGGING ERRORS WITH NO LIMIT;

Snowflake

OUT -> Teradata_03.sql

INSERT INTO MY_TABLE SELECT
*
FROM
MY_SAMPLE;

LOGGING ERRORS WITH LIMIT OF

In this example, notice that LOGGING ERRORS WITH LIMIT OF has been removed because it is not a relevant syntax. The syntax is not required in Snowflake.

Teradata

IN -> Teradata_04.sql

INSERT INTO MY_TABLE
SELECT *
FROM MY_SAMPLE
LOGGING ERRORS WITH LIMIT OF 100;

Snowflake

OUT -> Teradata_04.sql

INSERT INTO MY_TABLE SELECT
*
FROM
MY_SAMPLE;

Known Issues

No issues were found.

Related EWIs

No related EWIs.