KPI Partners Blog

Data Security Snowflake Part 2 - Column Level Security

Posted by KPI Partners News Team on Fri, Dec 04, 2020 @ 07:59 AM

by Ramana Kumar Gunti

Data Security in Snowflake using CLS

Large companies and professional businesses have to make sure that data is kept secure based on the roles and responsibilities of the users who are trying to access the data. One way to protect data is to enforce “Column Level Security” (CLS) to ensure that people can only access what they are supposed to see.

In this article, We will show how the Column Level Security can be implemented by using one of the Snowflake feature Data Masking Policy. So, Let’s get started!!

Read More

Tags: Blog, Snowflake, Data Security in Snowflake, Row Level Security

Data Security Snowflake Part 1 - Row Level Security

Posted by KPI Partners News Team on Fri, Dec 04, 2020 @ 07:58 AM

by Ramana Kumar Gunti

Data Security in Snowflake using RLS

Large companies and professional businesses have to make sure that data is kept secure based on the roles and responsibilities of the users who are trying to access the data. One way to protect data is to enforce “Row Level Security” (RLS) to ensure that people can only access what they are supposed to see.

Snowflake working on fine-tuning the Row Access policies for general availability. In this article, we will show an approach to restrict the Row Level Data to Authorized users by using the Snowflake Functions CURRENT_ROLE , CURRENT_USER

So, Let’s get started!!

Read More

Tags: Blog, Snowflake, Ramana Kumar Gunti, Data Security Snowflake, Column Level Security

Data Sharing in Snowflake

Posted by KPI Partners News Team on Tue, Nov 10, 2020 @ 03:22 AM

by Ramana Kumar Gunti

Data Sharing in Snowflake

In this article, we will talk about Snowflake data sharing which enables account-to-account sharing of data through Snowflake database tables, secure views, and secure UDFs. So let's get started.

Snowflake data sharing is a powerful yet simple feature to share the data from one account and to use the shared data from another account. The data producer can provide access to his live data within minutes without copying or moving the data to any number of data consumers. The data consumer can query the shared data from data producer without any performance bottle necks thanks to snowflakes multi-cluster shared data architecture.

Read More

Tags: Oracle Data Integrator (ODI), Blog, Snowflake, Data Sharing in Snowflake, Ramana Kumar Gunti

Oracle Data Integrator with Snowflake

Posted by KPI Partners News Team on Thu, Sep 24, 2020 @ 07:21 PM

by Abdul Mathin Shaik

Oracle Data Integrator with Snowflake

In this article, we will talk about how to load the data into the Snowflake data warehouse using Oracle Data Integrator ODI. So let's get started.

Lately, one of our Snowflake customers was looking to use Oracle Data Integrator to load data into Snowflake from oracle DW. I have been working with Oracle applications such as ODI for years now, so I wanted to explore how to configure ODI to work with Snowflake. 

Read More

Tags: Oracle Data Integrator (ODI), Blog, Snowflake, ODI with Snowflake, Abdul Mathin Shaik