
How to test your row access policies
Snowflake offers us the possibility to restrict user access to data within a table. We can use row access policies and masking policies for that. See my blog on the
Graduated as a linguist, Mario worked as a composer for several years. In addition, he has always maintained and expanded his scripting skills (including Python) learned at university. After retraining at the Hogeschool van Amsterdam (Make IT Work), Mario started working at The Information Lab Netherlands.
Data Engineering plays a growing social role and is therefore more and more bound by laws and regulations. Mario's interest in this is an added value, especially when care and responsibility are important in addition to software craftsmanship.
With a broad background, extensive experience in project-based work and a great deal of enthusiasm and eagerness to learn, he can contribute to answering important business issues.
Snowflake offers us the possibility to restrict user access to data within a table. We can use row access policies and masking policies for that. See my blog on the
Creating and querying a Snowflake semi-structured OBJECT Snowflake has a lot of features. One very handy feature is that it can handle semi-structured data natively. This can be done with
The OBJECT data type in Snowflake In this blog we will explore the OBJECT data type in Snowflake. This is a very useful data type because it allows us to
Cookie | Duration | Description |
---|---|---|
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |