TextQL Notebooks provide an AI-enhanced environment for data analysis and exploration. Building upon the familiar Jupyter notebook interface, our notebooks integrate seamlessly with TextQL’s AI capabilities to create a powerful platform for both interactive development and automated workflows.

TextQL is working to embellish this documentation with figures. Please check back later for a figure detailing the notebook interface with Python and SQL cells side by side, showcasing the polyglot capabilities.

Core Features

TextQL Notebooks extend traditional notebook functionality with AI-powered assistance and polyglot support. Each notebook is structured as a directed acyclic graph (DAG), allowing for complex workflows while maintaining the familiar cell-based interface. The system supports both Python and SQL cells, enabling seamless transitions between data manipulation paradigms.

TextQL is working to embellish this documentation with figures. Please check back later for a figure detailing the DAG structure visualization of a notebook, showing how cells connect and flow.

Cell Types

The notebook environment supports multiple cell types to accommodate various data science workflows:

  • Python Cells: Execute Python code with full access to data science libraries
  • SQL Cells: Write and execute SQL queries directly within your notebook
  • Markdown Cells: Document your analysis with rich text formatting
  • Advanced Components: Leverage specialized cells for file exploration, object exploration, and metric analysis

AI Integration

TextQL’s AI assistant enhances the notebook experience by providing intelligent suggestions, helping with code generation, and assisting in data analysis. The AI understands the context of your work through the notebook’s DAG structure, enabling more relevant and accurate assistance throughout your workflow.

Workflow Automation

Notebooks can be saved as reusable workflows and scheduled for automated execution. This feature transforms interactive analysis into production-ready data pipelines. While scheduled runs are currently in beta, you can already save and modify workflows for later execution.

TextQL is working to embellish this documentation with figures. Please check back later for a figure showing the workflow scheduling interface, highlighting the automation capabilities.

Getting Started

To create a new notebook, navigate to the Notebooks page and click “New Notebook.” The interface presents a split-pane view with your notebook cells on the left and a context-aware sidebar on the right. Add cells using the toolbar, selecting the appropriate cell type for your task.

Execute cells individually using the run button in each cell’s toolbar, or run all cells using the “Run All” button at the top of the notebook. Changes are automatically tracked and can be saved using the “Save” button.