top of page
Writer's pictureWix Engineering

Quix Version 1: Now also Supporting Amazon Athena, Google BigQuery and Generic JDBC

Updated: Apr 12, 2020



Quix logo

What is Quix?


Quix is an open source notebook manager that’s focused on ease of use and shareability and aims to be a shared space for your company's BI insights and know-how.


Quix note example
Quix note example

Quix was developed by the Data team in Wix after we switched to Presto as our main query engine, which allowed everyone in the company with basic SQL skills to query our analytical data and made Quix a widely adopted go-to tool for everything BI in Wix. You can read more about it in our Introducing Quix blog post.


If you're in the market for an intuitive and fast tool to query and share your data, give Quix a try:




New in this release


Since the official announcement this summer, and following requests from our first users, we added support for more data sources (Athena, BigQuery, JDBC), significantly reduced the installation size, tweaked the visualizations, fixed usability bugs and improved the documentation.



Full list of features available in Quix right now


Notebook/note management with multi-user support


  • Shareable folders/notebooks/notes

  • Favorite notebooks

  • Full-text note search across all users

  • Read Only access to the notebooks of all users


Query editor

  • Multiple statements

  • Syntax highlighting

  • Live syntax validation and autocompletion (currently for Presto only)

  • Keyboard shortcuts

  • Typed parameters (String, Boolean, Number, Date, Option, List)

  • Export results as CSV


One-click visualizations

  • Timeline chart

  • Bar chart

  • Pie chart


DB types you can query

  • Presto (supports live syntax validation and basic autocompletion)

  • Amazon Athena

  • Google BigQuery

  • Generic JDBC (MySQL, PostgreSQL, SQL Server, ClickHouse, etc...)


DB Explorer

  • Navigate, search and preview your catalogs and tables


What's in the pipeline?

  • Python note

  • More SSO options (OpenID)

  • More visualizations

  • Note embedding

  • Scheduled queries

  • Public queries

  • SDK for extending the base functionality of Quix


Contributors


@frolovv (Valery Frolov), @sthuck (Aviad Hadad), @antonpod (Anton Podolsky), @ittaym, @yaarams (Yaara Cohen), @stas-slu (Stas Slutsker), @shl3vi (Shahar Levi), @amitmarx (Amit Marx), @kgshv (Roman Kolgushev), @erezr (Erez Reuven)



 

For more engineering updates and insights:



bottom of page