Archive - 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

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

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

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

April 2020

Data Lake Chargebacks

Self Service Data Lakes require robust chargeback systems to ensure cost control and optimal ROI. Read on to discuss best practices in implementing…

Apr 10, 2020 •

Rajat Venkatesh

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

January 2020

This edition is a survey of data catalogs for big data. Data Catalogs manage metadata of data and are a foundation for data governance, privacy and…

Jan 19, 2020 •

Rajat Venkatesh

MySQL Governance

This issue will focus on governance, privacy and security of MySQL production databases.

Jan 9, 2020 •

Rajat Venkatesh

News about data infrastructure required to meet Data Governance, Security and Privacy requirements

Welcome to Data Governance, Privacy and Security by me, Rajat Venkatesh.

Jan 7, 2020 •

Rajat Venkatesh

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts