In Snowflake objects are hierarchically ordered. This means that at the top you will find the organization, then the account all the way down until you’re at the level of tables. A graphical representation of this hierarchy is provided at the end of the post. This hierarchy is important when discussing the security of Snowflake.…
Is there someone you trust, but really don’t trust? Meaning, you would like to give him access to e.g. an S3 Bucket, but you don’t want to share authentication data with him? Storage Integrations are a great way of giving untrustworthy individuals access in such a manner! Kidding aside, Storage Integrations are a great way…
Imagine you really do not like someone and you happen to know his IP address. With the power of a Network Policy, you can block him from your Snowflake account! That will that will teach him not steal you desk every single time! You don’t do flexible workspaces! All kidding aside, Network Policies are a…
SnowSQL is the Command Line client for connecting with Snowflake. After connecting, you can use SnowSQL to execute SQL queries and perform DDL and DML operations. However, with SnowSQL being a CLI, it is not as easy to use as SnowSight (the browser-based UI of Snowflake). That being said, a recent course taught me a…
Snowflake is primarily known in my circles as a cloud Data Warehouse provider. But did you know that you can also build Dashboards in Snowflake, using SQL queries? Below is an example of a Dashboard built in Snowflake. Right now, the dashboards do not have the same visualization capabilities of e.g. Power BI or Tableau.…
There is an easy way to track the lineage of Snowflake objects now. Whenever checking an object in Snowflake, you can visit the Lineage tab and check out the complete pipeline in Snowflake. Awesome.
Searching a certain value in ANY column in a table has never been easier in Snowflake. Imagine you have an order number, and you would like to search for this order number in a whole bunch of tables that you do not know well. If you knew which column to search, this would be easy:…
Did you know you can use SQL queries in your Python worksheets in Snowflake? This works as follows: dataframe = session.sql( ”’ YOUR SQL QUERY GOES HERE ”’ ) And voila! Don’t forget to return it in the function in the worksheet if you wish to inspect the resulting dataframe in the results pane. I…
Are you looking for a way to speed up queries in Snowflake without altering the size of the warehouse? One way you might achieve this is by taking the largest table in your query and applying the necessary filters before you start using it in your query. This means that the aforementioned largest table that…
In Snowflake there are useful commands like SHOW USERS (shows the users in your environment) or SHOW GRANTS TO ROLE (shows the privileges given to a certain role). The results of these commands are shown like tables however, you cannot filter them like SHOW USERS WHERE … You can however use the commands TABLE and…