Recent Articles

All Data Marketplace Flexter FlowHigh JSON Snowflake XML
Data Warehouse, Snowflake,

Using Virtual Data Marts the right way

Virtual data marts can be a useful design pattern but there are a few things you should know before you use them. Virtual data marts are logical views dimensionally modelled…
Uli Bethke May 26, 2021
Snowflake, Snowflake, XML,

Converting XML to Snowflake Vs. Redshift, BigQuery, Azure Synapse (Guide)

With the growth of data, variety in data formats, and cloud computing, there's an increased need for storing and analysing the rising volume of semi-structured data. The data originating from…
abbi May 24, 2021
Snowflake, Snowflake,

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
Snowflake, Snowflake,

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
Data Marketplace, Data Marketplace, Snowflake,

The Data Marketplace. A missing piece in modern data architecture

What is a Data Marketplace? Data Marketplaces are a relatively recent phenomenon in data management. They bring together providers and buyers of data. Organisations were able to buy data from…
Uli Bethke December 16, 2020
Snowflake, Snowflake,

Location analytics and geospatial data on Snowflake

What is Geospatial / GIS data? Geospatial data and location analytics Geospatial Data can be defined as data with a geographic component, e.g. Address, ZipCode, latitude / longitude etc. These…
Uli Bethke December 9, 2020