In this blog post I will explain what a view is and how to create one, then I will discuss materialized views and secure views. While views and materialized views are common database concepts, the section concerning secure views is specific to Snowflake. Views A view is a database object resulting from an underlying query. […]
We do everything to make your company data driven, by connecting to relevant data, store the data in data warehouse or data lake, designing the data, and visualise this. You and your colleagues can easily analyse the data and make the right decisions. We advise you what licenses work best for you, provide support, organise all relevant training and have the best consultants in the market.
When I study, I like to create tree diagrams, colorful mind maps and really anything that will help the information sink deeper into my memory and understanding. While studying for the Snowflake certifications, I reproduced the information concerning Snowflake roles on paper: Once I was done, I thought it would be handy to create a […]
Snowflake offers five default roles. It is important to understand the default Snowflake roles as they can help you managing access control to data within your organisation. These default roles are hierarchically ordered: each role inherits the capabilities of the roles below it. Drawing from the Snowflake documentation on roles, I have built a tree […]