Transaction, Commit and Rollback in Snowflake

To know more about Transaction in Snowflake , you can refer this link--
https://docs.snowflake.com/en/sql-reference/transactions.html
If you want to implement Transaction in Snowflake using Python connector , then you can refer this link for details :
https://docs.snowflake.com/en/user-guide/python-connector-example.htm #using-context-manager-to-connect-and-control-transactions

Code:
----------
drop database if exists ramu;


create database if not exists ramu;


use ramu;




alter session set autocommit = False;


start transaction name demo1;


show transactions;


create or replace table employee_history(employee_id number,
empl_join_date date,
dept varchar(10),
salary number,
manager_id number);

insert into employee_history values(8,'2014-10-01','HR',40000,4),
(12,'2014-09-01','Tech',50000,9),
(3,'2018-09-01','Marketing',30000,5),
(4,'2017-09-01','HR',10000,5),
(25,'2019-09-01','HR',35000,9),
(12,'2014-09-01','Tech',50000,9),
(86,'2015-09-01','Tech',90000,4),
(73,'2016-09-01','Marketing',20000,1);


select * from employee_history;




commit;


select * from employee_history;


show transactions;


-----------------------------------------------------------------------------------------------------------------------




start transaction name demo2;


show transactions;


create or replace table employee_history_demo2(employee_id number,
empl_join_date date,
dept varchar(10),
salary number,
manager_id number);

insert into employee_history_demo2 values(8,'2014-10-01','HR',40000,4),
(12,'2014-09-01','Tech',50000,9),
(3,'2018-09-01','Marketing',30000,5),
(4,'2017-09-01','HR',10000,5),
(25,'2019-09-01','HR',35000,9),
(12,'2014-09-01','Tech',50000,9),
(86,'2015-09-01','Tech',90000,4),
(73,'2016-09-01','Marketing',20000,1);


select * from employee_history_demo2;




rollback;


select * from employee_history_demo2;


-----------------------------------------------------------------------------------------------------------------------




show transactions;


alter session set autocommit = True;




Check this playlist for more AWS Projects in Big Data domain:
https://youtube.com/playlist?list=PLjfRmoYoxpNopPjdACgS5XTfdjyBcuGku