7 Techniques for Handling Changing Data During Semi-Structured Data Ingestion

Faced this issue at least twice in last couple of years, one of the most frustrating and redundant problem to solve.

wrote a blog around handling changing data types while ingesting a JSON data (from mongodb or other no-sql dbs) to a sql environment and how current ETL tools handle such changes