Snowflake : System defined roles in Snowflake

There are a total 5 default system-defined roles in snowflake, those are ACCOUNTADMIN SYSADMIN SECURITYADMIN USERADMIN PUBLIC Below is a graphical hierarchy of these roles in snowflakeACCOUNTADMIN is a top-level role in snowflake architecture,...

Read More

Snowflake : show databases command optimized

In snowflake, we use the "show databases" command to see details about default and created databases, this command shows a lot of details about databases, what if we just need the names of the database not whole details about them, after digging out I found this "databases" is table present in INFORMATION_SCHEMA schema, so we can query the details...

Read More

Snowflake : spool output in log file

In almost all databases features, we have a spool file option, we will discuss the same spool option in snowflakeAssume, you need to execute the script which is a little long and the output can not be captured in a single screenshot, so we can make use of spooling the output in the log file. once you are ready to execute the script, browse to...

Read More

Snowflake : Undrop database command

Snowflake database has a lot of features and benefits over the traditional database, one of the features is undrop database, assume you changed your mind after dropping a database, you can undo it using undrop database command, let's see how exactly it works. this particular feature is based on the time travel feature of the snowflake, a schema, database...

Read More

Snowflake : Using snowsql for snowflake database

A snowflake data warehouse is the latest addition to the trending database technology, In this article, we will be discussing snowsql, a command line tool used to access the snowflake database, there is another way as well to access the database i.e. web-based portal. still, there are many DBA's who love working on the command line instead of a web-based...

Read More

Snowflake : Different editions of snowflake

 As we know, the snowflake is a very hot data warehouse technology today. we will see a different aspect of a snowflake in different articles, here we will discuss its different editions available for use.  The below image gives an...

Read More

Snowflake : Introduction and Architecture

Snowflake is a very trending data warehouse technology due to its benefits and features over traditional database technology, here we will have a brief introduction to snowflake data warehouse and its architecture  Snowflake is true software...

Read More

Snowflake- what is account name in snowflake login

Snowflake is a really hot topic in 2021 and 2022 due to its benefits over traditional database offerings, Here I will show you, to check the account name in the snowflake portal, for login to snowflake you can use the link https://app.snowflake.com/,...

Read More