ecobee chooses Flexter to make valuable IoT data in XML accessible to BigQuery users for analytics

Uli Bethke BigQuery, XML

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

Uli Bethke Snowflake

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  

Uli Bethke Uncategorized

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 Covid XML and JSON to Yellowbrick

Uli Bethke Data Warehouse

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