Do you have employees who spend hours manually copying values from invoices into Excel or a database? Would you like to automate this? Automatically extracting values from unstructured data like JPG or PDF files is really easy. Snowflake has a feature that will help you with just that. You train a model once to extract…
Privilege inheritance in Snowflake’s role hierarchy is a powerful feature that simplifies access management and reduces administrative overhead. In Snowflake, roles can be granted to other roles, creating a hierarchical structure. Privileges associated with a role are inherited by any roles above it in the hierarchy. This means that when you grant a privilege to…
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…