Skip to main content
Skip table of contents

COMMIT

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

BASH
COMMIT <table> [FORCE]

<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.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.