Uli Bethke (@ubethke) header
Uli Bethke (@ubethke) profile picture

CEO Sonra. Parse any SQL. Data Lineage. Convert any XML and JSON.

Dublin
Joined April 2009
Photo by Uli Bethke (@ubethke)Photo by Uli Bethke (@ubethke)Photo by Uli Bethke (@ubethke)Photo by Uli Bethke (@ubethke)Photo by Uli Bethke (@ubethke)Photo by Uli Bethke (@ubethke)Photo by Uli Bethke (@ubethke)Photo by Uli Bethke (@ubethke)
#DimensionalModels on #Hadoop and #BigData technologies. Are they obsolete? ow.ly/c9GJ30ccldb
2
12
2
18
I need my network's help. We are currently working on a product feature to generate DDL from SQL (it is a by-product of some bigger app). This feature will let you generate DDL from inline views or CTEs, e.g. in the screenshot you would get 5 table DDLs. 1/2
1
1
4 DDLs for the three inline views and the final output and one for the physical table OrderLines. Now here my question: what use cases do you see for this feature? One use case I see is partial materialisation during #ETL #SQL 2/2
1
Find out how you can benefit from using geospatial data, the data marketplace and location analytics on the Snowflake data platform. sonra.io/2020/10/15/location…
2
7
Snowflake Cloud Data Platform web user experience enhanced with new app: Snowflake Snowsight. We walk you through 7 refreshing #Snowsight UI features + tips & tricks sonra.io/2020/07/16/snowflak…
4
MedVault Analytics: primary healthcare practice solution on Snowflake Cloud Data Platform(separation of data workloads, E2E encryption, utility billing). Less clinical staff admin.+increased reimbursements=thousands € savings per practice sonra.io/2020/06/29/medvault…
3
In this blog post we pair up Snowflake with Qlik Replicate for streaming and real time analytics sonra.io/2020/06/12/snowflak…
3
Point and click ETL tools have failed data prfoessionals again and again. In this blog post we look at the history of ETL, the limitations of ETL tools and the unstoppable rise of data warehouse automation sonra.io/2020/05/22/to-hell-…
1
3
Converting XML and KML documents from OpenStreetMap Ireland and Irish geodata. Integrating Irish census data with the geodata. Analysing the census and geodata from Ireland. sonra.io/2020/04/14/geo-and-…
2
Automatically generate a relational database schema from XML, XSD, or JSON. sonra.io/2020/04/07/generati…
1
How optimisation algorithms can simplify the structure of your target schema when converting XML/JSON to a relational format. sonra.io/2020/03/31/optimisa…
1
This hands on blog post walks you through some scenarios and examples of using the Snowflake data platform for data preparation and ETL. sonra.io/2020/05/28/the-snow…
Checklist for a successful data lake implementation sonra.io/2018/05/22/checklis…
1
2
good post on indexes in columnar storage using parquet as reference but relevant in general lnkd.in/dM-wEY5
We use Flexter to convert 3GPP Configuration Management XML (3G, UMTS, 5G) to Snowflake. Configuration data is very complex, recursive, and comes in very large files. A perfect fit for Flexter. sonra.io/2019/08/23/converti…
1