7 Techniques for Handling Changing Data During Semi-Structured Data Ingestion (datazip.io)

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

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