The challenge A world leader in smart home devices that introduced the world’s first smart thermostat, ecobee has expanded rapidly in the last decade. Naturally, with company growth has come a surge in the amount of data generated by the company, particularly from their sensor devices – and subsequently, the need for clean data, analytics, and standardized reporting across the ...
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 third parties in the past. However, Data Marketplaces make it significantly easier to find and buy data. They also cut out the middleman and bring providers and consumers of data ...
Snowflake Data Marketplace: UK Administrative Boundaries
Overview We have published administrative boundary data for the UK on the Snowflake data marketplace. In this blog post we document what you need to know about the data including the data model and sample queries. Reach out to us if you have a requirement for administrative boundaries from other countries. Administrative boundary data covers the geographic hierarchy of national ...
Converting XML documents from an Oracle CLOB to a relational format
In this post we will show you how easy it is to convert XML data from Oracle CLOB to a relational format. We will be using Enterprise Flexter which ships with a feature that enables us to use Oracle CLOB as source data and to convert it. Flexter is available in three editions. An enterprise edition, which can be installed ...
Converting Covid XML and JSON to Yellowbrick
Sonra has recently certified Flexter against Yellowbrick. In this blog post we show you how Flexter and Yellowbrick work together to easily convert and query data that is locked away in XML or JSON documents. Using Flexter we convert XML and JSON documents to tables in Yellowbrick without writing a single line of code. We then run SQL queries ...