Hex
WebsiteThe Data Workspace for Teams. Work with data in collaborative SQL and Python notebooks. Share as interactive data apps that anyone can use.
Hex vs Querybook:
a side-by-side comparison for 2024
Comparing two data science notebooks.
Querybook
WebsiteQuerybook is Pinterest’s open-source big data IDE via a notebook interface.
Hex
Querybook
Setup
Fully managed (setup in minutes)
No, you must host it yourself
Can you self-host?
Can you self-host?
No, you must use a managed offering
You can self-host (setup in hours)
Features
Is it Jupyter compatible?
Is it Jupyter compatible?
Jupyter-compatible
Not Jupyter-compatible
Programming languages
Programming languages
Jupyter languages (e.g. Python, R)
SQL
Python
What kind of data sources can you connect to?
What kind of data sources can you connect to?
Connect with Jupyter libraries (e.g. SQLAlchemy, psycopg2)
Connect to data warehouses (Google BigQuery, ClickHouse, etc.)
Connect to databases (MariaDB, SQL Server, etc.)
Provided file storage
Connect to data warehouses (Snowflake, Google BigQuery, etc.)
Connect to databases (PostgreSQL, MySQL, etc.)
What kind of data visualization can you do?
What kind of data visualization can you do?
Jupyter data visualization (e.g. Matplotlib, Altair, Plotly)
UI for building charts
UI for building charts
Reactivity
Reactivity
Full, realtime reactivity
No reactivity, you decide the execution order
Notebook scheduling is built in
Notebook scheduling is built in
Management
Reproducibility
Reproducibility
Environments are reproducible by default
Execution is reproducible by default
Run notebooks in containers
With effort, you can make reproducible environments
Version history is built in
No version history
Multiple editors at the same time
Multiple editors at the same time
Comments
Comments
Comment on items within a notebook
No support for comments
Notebook organization
Notebook organization
View notebooks in a list
Unknown
Licensing
License
License
Proprietary
Open-source (Apache 2.0)
Price
Price
Free tier
Pay-per-user
Pay for compute
Free