How to Resetting Your Snowflake Environment.

If you would like to reset your environment by deleting all the objects created as part of this lab, run the SQL statements in a worksheet.
 
First, ensure you are using the ACCOUNTADMIN role in the worksheet :
use role accountadmin;
Then, run the following SQL commands to drop all the objects we created in the lab :
drop share if exists zero_to_snowflake_shared_data;
-- If necessary, replace "zero_to_snowflake-shared_data" with the name you used for the share

drop database if exists citibike;

drop database if exists weather;

drop warehouse if exists analytics_wh;

drop role if exists junior_dba;