• Black Twitter Icon
  • Black YouTube Icon

At Wix Engineering we develop some of the most innovative cloud-based web applications that influence our +150 million users worldwide.

Have any questions?
Email: wixeng@wix.com

Trademarks and logos of other parties appearing in this post are the property of their respective holders.

Get Wix Engineering Straight to Your e-mail

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



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 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)

96 views