Mode Notebooks
Native R & Python Notebooks. From SQL, explore your analysis using R or Python Notebooks.
Mode Notebooks vs Querybook:
a side-by-side comparison for 2024
Comparing two data science notebooks.
Querybook
Querybook is Pinterest’s open-source big data IDE via a notebook interface.
Mode Notebooks
Querybook
Setup
Is it managed?
Is it managed?
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?
Not Jupyter-compatible
Not Jupyter-compatible
Programming languages
Programming languages
SQL
R
Python
Python
What kind of data sources can you connect to?
What kind of data sources can you connect to?
Connect to databases (MariaDB, PostgreSQL, etc.)
Connect to data warehouses (Amazon Redshift, Google BigQuery, etc.)
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?
UI for building charts
UI for building charts
Reactivity
Reactivity
No reactivity, you decide the execution order
No reactivity, you decide the execution order
Notebook scheduling
Notebook scheduling
Notebook scheduling is built in
Notebook scheduling is built in
Management
Reproducibility
Reproducibility
Environments are reproducible by default
With effort, you can make reproducible environments
Version history
Version history
No version history
No version history
Collaborative editing
Collaborative editing
Multiple editors, one at a time (asynchronous)
Multiple editors at the same time
Comments
Comments
No support for comments
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
Unknown
Free