Blog

Data discovery in Kognitio with TFL and Tableau

Jul 06, 2017 | By Chak Leung

(Power by TFL Open Data, Contains OS data © Crown copyright and database rights 2016) In previous blog posts I’ve gone over ways to push data to S3 and connect to it via Kognitio external tables (link). I’ll be using that method on some bus data provided by Transport for London (TFL) and accelerating a…

Read more

Visiting my neighbour S3 and his son JSON

May 23, 2017 | By Chak Leung

They also live across the river and there’s no bridge…so we’ll just make our own! Amazon’s S3 is a popular and convenient storage solution which many, especially those with big data, tend to utilise, and the challenge can be connecting to this large store that has been building up over days/weeks/months/years. There are many ways…

Read more

The loneliest railway station in Britain

May 18, 2017 | By Graeme Cole

In my last blog post, I introduced Kognitio’s ability to flatten complex JSON objects for loading into a table. Today we’ll look at another example using real-world Ordnance Survey data. We’ll also look at what you can do if the JSON files you need to load are in HDFS. We’ll use these techniques to solve…

Read more