Predictive Hacks

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;

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

Subscribe To Our Newsletter

Get updates and learn from the best

More To Explore


Image Captioning with HuggingFace

Image captioning with AI is a fascinating application of artificial intelligence (AI) that involves generating textual descriptions for images automatically.


Intro to Chatbots with HuggingFace

In this tutorial, we will show you how to use the Transformers library from HuggingFace to build chatbot pipelines. Let’s