Video: Converting FpML XML to Snowflake
Uli Bethke October 23, 2020

Snowflake date and time dimension

Here is a simple SQL script that will generate a date dimension in Snowflake. We are using the built-in GENERATOR and SEQ function. Start date for the dimension is 2017-01-01.…
Uli Bethke January 28, 2019

Sonra to present at DataWorks Summit San Jose (17-21 June)

Our CEO Uli Bethke will co-present with Avi Sawant from Cincinnati Insurance Company on how Flexter, our powerful ETL tool for XML and JSON, converts large volumes of ACORD based…
Uli Bethke June 8, 2018

Checklist for a successful data lake implementation

In two recent blog posts I have outlined Sonra’s vision for a data lake architecture. In the first one I discussed various flaws in the data lake concept. In the…
Uli Bethke May 22, 2018

You might be surprised to hear, but Hadoop is a poor choice for a data lake

As there are a lot of definitions on what constitutes a data lake let’s first define what we actually mean by it. A data lake is similar to the staging…
Uli Bethke May 3, 2018

Flexter 1.2.0 our ETL tool for JSON/XML has been released. 20x faster. Supports very large XML and JSON

We have release Flexter 1.2.0 this week. We have added some significant new features and improvements. Flexter now supports conversion of JSON to a database, text (CSV/TSV), and Hadoop/Spark (ORC,…
Uli Bethke February 23, 2018