Blog Posts

DData Governance 101

Rajat Venkatesh — 07/10/20203 Min Read — In Data Governance

What is Data Governance? The first step is to understand what is data governance. Data Governance is an overloaded term and means different things to different people. It has been helpful to define…

DData Lineage on Snowflake

Rajat Venkatesh — 07/01/20201 Min Read — In Snowflake, Data Lineage

This blog will describe how to generate data lineage using the data-lineage python package from query history in Snowflake. data-lineage generates DAG from parsing SQL statements in query history…

FFAQs on Data Lineage

Rajat Venkatesh — 02/29/20201 Min Read — In Data Lineage

What is meant by data lineage ? In Biology, lineage is a sequence of species each of which is considered to have evolved from its predecessor. Similarly, Data Lineage is a sequence of transformations…

FFAQs on Database Audits

Rajat Venkatesh — 02/15/20201 Min Read — In Database Audit

What is database auditing ? Database Audits track two important activities in databases: User Login Database Object Access User Login In postmortems, it is important to get a list of humans (vs micro…

FFAQs on Data Catalog

Rajat Venkatesh — 01/30/20202 Min Read — In Data Catalog

Why do you need a data catalog ? A data catalog is important to solve two problems in modern data teams: Avoid poor productivity of people and the ROI of data. Governance Risk Productivity Analysts…

TTokern DbAudit and GDPR / CCPA

Rajat Venkatesh — 01/16/20202 Min Read — In GDPR, CCPA, Database Audit

GDPR or General Data Protection Regulation is a EU law on data protection and privacy. More recently, California passed its own privacy law, CCPA or the California Consumer Privacy Act. The CCPA…

DData Security Incidents Analysis

Rajat Venkatesh — 12/18/20191 Min Read — In Data Security, Data Breach

Veris Community compiles information security breaches and incidents based on a standard. They also maintain database of incidents - VCDB regularly updated by the community. Caveat: The community…

DData Lineage on Redshift

Rajat Venkatesh — 09/20/20193 Min Read — In AWS Redshift, Data Lineage

Data Lineage tracks data transformation through all systems. It is important for data governance and security. In Data warehouses and data lakes, a team of data engineers maintain a canonical set of…