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