ROLLBACK | Snowflake Documentation (original) (raw)

Begin a transaction, insert some values into a table, and then complete the transaction by rolling back the changes made in the transaction:

SELECT COUNT(*) FROM A1;

+----------+ | COUNT(*) | |----------+ | 0 | +----------+

BEGIN NAME T4;

SELECT CURRENT_TRANSACTION();

+-----------------------+ | CURRENT_TRANSACTION() | |-----------------------+ | 1432071523422 | +-----------------------+

INSERT INTO A1 VALUES (1), (2);

+-------------------------+ | number of rows inserted | |-------------------------+ | 2 | +-------------------------+

ROLLBACK;

SELECT COUNT(*) FROM A1;

+----------+ | COUNT(*) | |----------+ | 0 | +----------+

SELECT CURRENT_TRANSACTION();

+-----------------------+ | CURRENT_TRANSACTION() | |-----------------------+ | [NULL] | +-----------------------+

SELECT LAST_TRANSACTION();

+--------------------+ | LAST_TRANSACTION() | |--------------------+ | 1432071523422 | +--------------------+