ecobee chooses Flexter to make valuable IoT data in XML accessible to BigQuery users for analytics
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, ...Read More
SQL on Hadoop, BigQuery, or Exadata. Please don’t call them MPP.
I often hear people referring to SQL engines running against HDFS or object storage as MPP. Strictly speaking this is incorrect. Let me first explain what an MPP database is and then explain why engines such as Presto etc. should not be called an MPP engine. MPP In an MPP engine we evenly distribute data ...Read More
Convert FpML XML to BigQuery
About this walk-through In this walk-through we will load XML files processed by Flexter into BigQuery. Flexter is a powerful XML parsing tool that can convert complex XML files into readable format which can then be loaded into BigQuery which is an enterprise data warehouse available on the Google cloud platform. FpML XML Data We ...Read More