The COMMIT command assigns data operations to a table into the data warehouse. Those operations are:

  • LOAD
  • DELETE from 

Note: Truncate operation includes an implicit COMMIT.

Syntax

syntax

COMMIT <table> [FORCE]
BASH

<table>

The complete name of the table you want to commit to the warehouse. Eg. my_schema.my_table.

FORCE

If the previous load operations raise an error because the amount of data hit a size limit of index.memory.max_size or table.memory.max_size, this means the commit operation is not allowed in order to avoid committing a partial data change.

Rollback operation is recommended.

You can force the commit with the argument FORCE. This will ignore the error message and commit the partial data change even if incomplete.

Output

This SQL command does not return anything.