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:

• Online demo (requires a Google OAuth login)

• Quick start

• Full installation

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:

• Follow us on: Twitter | Facebook | LinkedIn

• Visit us on GitHub

• Subscribe to our monthly newsletter

• Subscribe to our YouTube channel

• Follow our Medium publication

• Listen to our podcast on Apple, Spotify or Google