How to Reset your Snowflake Environment

Assume that you follow some Snowflake tutorials and you would like to delete all the objects created as part of the tutorials. You can easily do it by running the following SQL commands.

use role accountadmin;
use warehouse compute_wh;
use database tutorial_db;
use schema public;


drop share if exists tutorial_share;
drop database if exists tutorial_db1;
drop database if exists tutorial_db2;
drop warehouse if exists tutorial_wh;
drop role if exists tutorial_new_role;