Video: Converting FpML XML to Snowflake

Uli Bethke October 23, 2020

Read More

Snowflake date and time dimension

Uli Bethke January 28, 2019

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. WITH CTE_MY_DATE AS ( SELECT DATEADD(HOUR, SEQ4(), '2017-01-01 00:00:00') AS MY_DATE FROM TABLE(GENERATOR(ROWCOUNT=>20000)) ) SELECT TO_DATE(MY_DATE) as date ,TO_TIME(MY_DATE) as time ,TO_TIMESTAMP(MY_DATE) as datetime ,YEAR(MY_DATE) ...

Read More

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

Uli Bethke June 8, 2018

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 insurance XMLs to ORC and Hive on the Hortonworks platform. Here is the abstract for the presentation. Add a SPARK to your ETL Wednesday, June ...

Read More

Checklist for a successful data lake implementation

Uli Bethke May 22, 2018

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 second, I argued that Hadoop or more precisely HDFS is a poor choice for a data lake. Let’s briefly recap the discussion. What is a ...

Read More
1 2 3 46