Blog Posts

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…