Databricks JSON Guide – Read, Parse, Query & Flatten Data

JSON and Databricks should work smoothly together. They don’t. Yes, Databricks can parse simple JSON files. It can also partially infer their schemas and process them in large chunks. But…

JSON to SQL & Database – Load, Query, Convert (Guide)

If you work with databases today, you’ve almost certainly come across the JSON data format. It powers everything from API integrations to event streams and user data, and it’s no…

How to Use the Flexter XML to SQL Database Converter Online

Converting deeply nested XML to database for free, without writing a single line of code. Too good to be true? With Flexter Online, it’s a reality. In this guide, I’ll…

XML to Database Converter – Tools, Tips, & XML to SQL Guide

Manually converting XML to a database sucks. If you’re anything like me, you’ve probably burned countless wasted hours wrestling with deeply nested XML and data mappings, misinterpreted XML attributes and…

SQL Visualisation Guide – Query Diagrams, Lineage & ERD

Have you ever inherited the SQL codebase from someone else where it is in a “bit of a mess”? 😁 Where you find nested CTEs (Common Table Expressions), stacked like…

Oracle EXTRACT & EXTRACTVALUE for XML (Guide & Examples)

When you need to extract and/or query an Oracle database for XML data, there are two SQL functions that come to mind, ‘EXTRACT’ and ‘EXTRACTVALUE’. I’m going to delve into…