I have an interesting situation where I should able to retrieve the individual column's data behind the visualization. The best would be if I could call an API in somewhere (like in dataserver) to retrieve one column's distinct dataset just like how Tableua does for quick filters.
Due to the amount of the data the CSV download and parse way is not really suitable. I have also tried to create my own controller and view in vizql webapp, but if there will be a good way to proceed with the underlying data API, that would be the best. C++ and Java APIs are also fine for me.