IGNORE

Learn how to use the IGNORE utility function in PlaidCloud Lakehouse. By using insert ignore statement, the rows with invalid data that cause the error are...

By using insert ignore statement, the rows with invalid data that cause the error are ignored and the rows with valid data are inserted into the table.

SQL Syntax

INSERT ignore INTO TABLE(column_list)
VALUES( value_list),
      ( value_list),
      ...