What is Tabix?
As part of my clickhouse setup series, I wanted to have a gui to work with, especally as a way for analysts without R and Python proficiency to query the database. Tabix seemed perfect for this; in addition the software had dashboarding capabilities for automated reports which seemed perfect.
Setting up tabix turns out to be incredibly simple. If you have followed my previous posts and set up clickhouse under wsl, then clickhouse will be running off localhost. First make sure cickhouse is running in wsl:
Since tabix can run off your browser it doesn’t even need to be installed. Simply launch the (browser)[http://ui.tabix.io/] and you will be prompted to connect:
Under name simply set up a name for your connection, in my case I called it local_ch, then point tabix to local host port 8123. Note that if you are setting up remotely this will be different. I plan to do a tutorial on remote setup later. Under login you’ll want to type ‘default’ since in my set up I haven’t added security; once again this will change if we set up remote systems and security in clickhouse. Once you are set, click sign in (I chose to click add new as well in order to store the data).
Once you sign in you will see the querying screen which is pretty intutive. Try and run the first query we ran from Mark Litwintschik’s blog. You should receive the following error:
To my knowledge this occurs becuse query time is greater than 5 seconds which is the default query time. Note that query time will vary based on your specs and tuning. In my case I didn’t tune the databse yet, and I also didn’t create the mergetree version of the table Mark did yet (you will see he creates a smaller table to query with optimized fields in his blog). Regardless I wanted to pump up the query time; all you have to do is go to settings on the top right and change the max exexution time in the new window from 5 to what your want (I put in 100 seconds):
Click apply on the bottom and you should be good to go. Rerun the query and voila:
Depending on the data you loaded you’ll have different numbers, note you can use the x circled in red to save your table.
##Conclusions And that’s how easy it is to connect tabix to your clickhouse instance locally under wsl. In my next post in this series I’ll explore how to set up some quick graphs for dashboard reports, something that is very valuable when dealing with large data like this.