How to Parse & Flatten XML in Snowflake With Examples

In this post we cover every detail of parsing XML in Snowflake including storing, loading, querying, and parsing XML. Very few cloud data platforms have native support for parsing XML.…
abbi June 3, 2024

Converting XML and JSON to a Data Lake

Data lakes are a popular design pattern in data analytics. A data lake is used to store a copy of data coming from operational source systems such as relational databases.…
Kristijan Berta September 30, 2021

Re-use algorithms for converting XML and JSON to a relational format

In our previous post Optimisation algorithms for converting XML and JSON to a relational format, we explained that Flexter ships with two optimisation algorithms. These algorithms make the life of…
Kristijan Berta May 5, 2020

Converting GDTF XML standard to MySQL

In this post we will guide you through the easiest way of processing your XML data to a relational format on MySQL . We will be using Flexter to process…
Kristijan Berta May 3, 2020

Geo and location analytics in action with OpenStreetMap and census data

Geo and location analytics in action with OpenStreetMap and census data In this blog post we integrate and analyse OpenStreetMap, Census, and Geo Data from Ireland. We will use Flexter…
Kristijan Berta April 14, 2020

Converting XSD to database schema: your guide to creating relational models from XML

When it comes to turning your XML/XSD into a relational schema, you’ve got a few paths you can take: Straight from the XSD: This method covers all possible XPaths and…
Kristijan Berta April 7, 2020
spinner