Skip to content

Notebook overview

The Notebook is a unified, AI-assisted analytics workspace that combines SQL and Python in one environment. It is designed for data exploration, transformation, and preparation in a secure, controlled, and collaborative setting.

Notebook is a collection of steps (called cells) that enables users to write and execute SQL queries and Python code within a single workspace, while leveraging AI assistance for faster development and analysis. It provides a safe, sandboxed environment for working with data without external dependencies.

  • SQL + Python in one place: Seamlessly switch between SQL queries and Python code within the same notebook to analyze and transform data efficiently.
  • AI assistance (no auto-execution): Get intelligent suggestions, query guidance, and code help from AI, while maintaining full control over execution.
  • Sandboxed environment: Runs in a secure environment with no external internet access, ensuring data privacy and controlled execution.
  • Data preparation and cleaning: Perform transformations, cleaning, and preprocessing using SQL or Python before publishing datasets.
  • Direct publishing to dashboards: Publish cleaned and prepared data sources directly to dashboards for visualization and reporting.

Whether you’re a data expert or a business user, Aira simplifies the analytical process — making it easier to discover, visualize, and understand your data without writing a single query.

  • Data cleaning and transformation workflows
  • Exploratory data analysis using SQL and Python
  • Preparing curated datasets for BI dashboards
  • Secure analytical development in enterprise environments