Priyansh KhodiyarforDatazipdatazip.io·Oct 18, 2024How to Flatten Object Types and Query Arrays in Semi-Structured Nested JSON for Effective Data ExtractionFlattening nested JSON or MongoDB’s BSON or normalizing semi-structured data and writing queries on it for analytics or regular queries, is a common challenge in data processing. In this article, we’ll explore multiple methods for extracting data fro...1.8K readsFlatbreadflatten
Priyansh KhodiyarforDatazipdatazip.io·Oct 10, 20247 Proven Techniques for Handling Changing Data Type during Semi-Structured Data Ingestion a.k.a Polymorphic KeysPolymorphic keys in semi-structured data—where a single field can hold values of different types (and to make things worse, they keep on changing each time) —are a challenge to deal with, especially when figuring out how exactly to store them in the ...174 readsOLakeSemi-Structured-Data
Priyansh KhodiyarforDatazipdatazip.io·Sep 23, 2024How to Query Semi-Structured JSON Data in Snowflake?Alright, let’s kick things off. In today’s world, where data comes in all shapes and sizes, querying semi-structured data has become super important. It’s not just about rows and columns anymore. Modern databases need to handle messy, complex data, l...570 readsFlatbreadsnowflake
