Notebooks

Create interactive documents with markdown and SQL code blocks for data analysis and documentation.

Kontext Notebooks provide a powerful, simple, interactive document environment similar to Jupyter Notebook, designed specifically for data analysis and documentation within the Kontext platform.

Create documents that seamlessly blend rich markdown content with executable SQL code blocks and dynamic visualizations.

Kontext Notebook List Screenshot

Overview

Notebooks in Kontext are block-based interactive documents that enable you to:

  • Combine documentation and analysis: Write rich markdown content alongside executable SQL queries
  • Execute SQL against your data: Run queries directly against datasets in your data lake
  • Visualize results: Generate charts and graphs from query results
  • Share insights: Export and share notebooks with your team
  • Iterative analysis: Build analysis step-by-step with executable blocks

Key Features

Block-Based Architecture

Notebooks are built on a flexible block system where each block can be:

  • Markdown blocks: Rich text with support for headers, lists, tables, math formulas (LaTeX), code snippets, and more.
  • SQL blocks: Executable code blocks that run queries against your datasets
  • Chart blocks: Data visualizations generated from SQL query results

SQL Execution

Execute SQL queries directly within notebook blocks:

SELECT
    customer_segment,
    COUNT(*) as customer_count,
    AVG(total_spend) as avg_spend
FROM customers
WHERE signup_date >= '2024-01-01'
GROUP BY customer_segment
ORDER BY avg_spend DESC;
  • Connect to any dataset in your project’s data lake
  • Real-time query execution with progress indicators
  • Error handling and query validation

Data Visualization

Transform query results into interactive visualizations:

  • Chart types: Bar charts, line charts, pie charts, scatter plots, and more
  • Powered by Ant Design Charts: Built on AntV (G2Plot) for high-quality visualizations
  • Interactive: Hover tooltips, zoom, and other interactive features
  • Customizable: Adjust colors, labels, and styling options

Rich Markdown Support

Create comprehensive documentation with:

  • Standard markdown formatting (headers, lists, links, images)
  • Mathematical formulas using LaTeX syntax
  • Code syntax highlighting for multiple languages
  • Tables and structured content
  • Cross-references and links

Future Enhancements

Python Support

Planned enhancements include:

  • Python code blocks: Execute Python scripts in browser using Pyodide or dedicated computing.
  • Data science libraries: Support for pandas, numpy, matplotlib
  • Mixed environments: Combine SQL and Python in the same notebook

Advanced Features

  • Collaborative editing: Real-time collaboration on notebooks
  • Scheduling: Automated notebook execution and reporting using Kontext Serverless Job Framework
  • Template library: Pre-built notebook templates for common analyses

Start creating interactive data stories with Kontext Notebooks today!