Uli Bethke

#DimensionalModels on #Hadoop and #BigData technologies. Are they obsolete? ow.ly/c9GJ30ccldb

When people hear Materialised Views they think performance boost for aggregate queries. 🤔 While true, Materialised Views can be used for a whole range of use cases other than aggregate navigation. sonra.io/flowhigh/mater… #sql #dataengineering #data

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

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

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/loc…

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/sno…

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/med…

In this blog post we pair up Snowflake with Qlik Replicate for streaming and real time analytics sonra.io/2020/06/12/sno…

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-…

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…

Automatically generate a relational database schema from XML, XSD, or JSON. sonra.io/2020/04/07/gen…

How optimisation algorithms can simplify the structure of your target schema when converting XML/JSON to a relational format. sonra.io/2020/03/31/opt…

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…

Checklist for a successful data lake implementation sonra.io/2018/05/22/che…

good post on indexes in columnar storage using parquet as reference but relevant in general lnkd.in/dM-wEY5

lnkd.in/djGU3fp lnkd.in/dYs5xCy

lnkd.in/d9ngWF3 lnkd.in/dS4_xci

lnkd.in/dxaj89j lnkd.in/dUtURRR

lnkd.in/dXQRHQC lnkd.in/dKNAq8X

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/con…