Data Governance, Privacy and Security

Two Methods to Scan for PII in Data Warehouses

Find PII data by scanning column names and/or data in your data warehouse

Nov 29, 2021 • 

Rajat Venkatesh

1

1

October 2021

Open Source SQL Parsers

Parsing SQL queries provides superpowers for monitoring data health. This post describes how to get started on parsing SQL for data observability.

Oct 8, 2021 • 

Rajat Venkatesh

1

January 2021

How to Get Started on Data Governance

This post describes the prerequisites as well as a methodology for a successful implementation of a data governance platform.

Jan 8, 2021 • 

Rajat Venkatesh

October 2020

A Practical Data Quality Process

This provides high level, practical tips to approach data quality.

Oct 18, 2020 • 

Rajat Venkatesh

September 2020

Data Catalogs, Dictionaries, Taxonomies and Glossaries

This post explores the different types of metadata on data and the different types of personas who use this metadata for their work.

Sep 18, 2020 • 

Rajat Venkatesh

2

July 2020

Data Governance 101

This post is a recap of my presentation on Data Governance 101 and is a semi-autobiographical journey in helping data teams setup data governance…

Jul 12, 2020 • 

Rajat Venkatesh

3

April 2020

March 2020

Automatic Schema Detection And Matching

Data analysts need to know the schema of all the data sets as well as which tables and columns represent common entities. Schema detection and matching…

Mar 5, 2020 • 

Rajat Venkatesh

February 2020

Auto-tune performance and cost

This post will explore techniques to optimize the usage and cost of compute and storage in databases and data lakes.

Feb 1, 2020 • 

Rajat Venkatesh

1

January 2020