Uli Bethke

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

[Uli Bethke @ubethke]

#DimensionalModels on #Hadoop and #BigData technologies. Are they obsolete?
https://t.co/k1NHEgTn7k

[Uli Bethke @ubethke]

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.
https://t.co/In11LElUVE

#sql #dataengineering #data

[Uli Bethke @ubethke]

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

[Uli Bethke @ubethke]

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

[Uli Bethke @ubethke]

Find out how you can benefit from using geospatial data, the data marketplace and location analytics on the Snowflake data platform.
https://t.co/VjRzSX34Yt

[Uli Bethke @ubethke]

Snowflake Cloud Data Platform web user experience enhanced with new app: Snowflake Snowsight. We walk you through 7 refreshing #Snowsight UI features + tips & tricks
https://t.co/VJJOW8XGOY

[Uli Bethke @ubethke]

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
https://t.co/6DYUGDz8kN

[Uli Bethke @ubethke]

In this blog post we pair up Snowflake with Qlik Replicate for streaming and real time analytics
https://t.co/BGO2SF1vRS

[Uli Bethke @ubethke]

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
https://t.co/zfpMSJVgrI

[Uli Bethke @ubethke]

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.
https://t.co/YkexhQJGvS

[Uli Bethke @ubethke]

Automatically generate a relational database schema from XML, XSD, or JSON.
https://t.co/qeVD0FLg59

[Uli Bethke @ubethke]

How optimisation algorithms can simplify the structure of your target schema when converting XML/JSON to a relational format.
https://t.co/RQcFVD4psA

[Uli Bethke @ubethke]

This hands on blog post walks you through some scenarios and examples of using the Snowflake data platform for data preparation and ETL.
https://t.co/k2h3zdGb5e

[Uli Bethke @ubethke]

Checklist for a successful data lake implementation
https://t.co/vKjug5XKwi

[Uli Bethke @ubethke]

good post on indexes in columnar storage using parquet as reference but relevant in general https://t.co/3fqrOwc8NZ

[Uli Bethke @ubethke]

https://t.co/gUOgsiOZk9 https://t.co/Aa5mIZjw3i

[Uli Bethke @ubethke]

https://t.co/BVHdNgxGyy https://t.co/Rip4yLwm7U

[Uli Bethke @ubethke]

https://t.co/0lbprPkkis https://t.co/dlwxwLulsA

[Uli Bethke @ubethke]

https://t.co/tikWPJigRV https://t.co/3Ej7WmYKfF

[Uli Bethke @ubethke]

https://t.co/IOMUettCRL

[Uli Bethke @ubethke]

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.
https://t.co/U3by5GX5rV