Top Articles

SQL Challenge: Tackling the Island Problem in Time Series Data

Jump into our SQL Challenge! Today, we’re exploring customer loyalty trends. Are you prepared to show off your SQL skills? About the quiz In this SQL pop quiz, we’re challenging you to demonstrate your understanding of islands in a time series data set. Whoever submits the correct and most performant query will be featured in …

Uli Bethke November 7, 2023

Location analytics on Snowflake with OpenStreetMap, US property data, and our ready made Geography Dimension

We have made available a ready made Geography Dimension on the Snowflake Data Marketplace. The marketplace is one of the components of the Snowflake Data Cloud. It covers the first to…
Uli Bethke February 19, 2021
XML, XML,

The 6 Factors You Need to Get Right to Make Your XML Conversion Project a Success

A successful XML conversion project makes data: Intelligible Readable, and Analysable Achieve that and decisions can be made quickly on accurate and reliable data. Unfortunately, many projects fail because of…
Uli Bethke February 18, 2021

Guide to Geography Dimension on the Snowflake Marketplace

We have published a universal Geography Dimension on the marketplace of the Snowflake Data Cloud. You can easily join the data with your in house data to look up location…
Uli Bethke February 3, 2021

The Secrets to Unlocking XML Data in an Optimised Format for Downstream Users

All the data in the world is not worth much unless you can use it. That means it must be intelligible, readable, and analysable. Organisations spend huge resources on data…
Uli Bethke January 22, 2021

Cloud Data Warehouse Consultant

Cloud Data Warehouse Consultant Sonra is looking for a cloud data warehouse consultant Join our growing team of the best data experts on the planet Work on data warehouse projects…
Uli Bethke January 14, 2021

Reverse Geocoding on Snowflake

In this blog post we will show how you can use OpenStreetMap data from the Snowflake data marketplace and the geospatial feature in the Snowflake data platform to reverse geocode…
Uli Bethke December 24, 2020
spinner