Notebooks

• Reactivity: how cells track their dependencies and re-run.
• SQL and Python: querying connections and using results as dataframes.
• Outputs and charts: tables, charts, and widgets.
• Environment and kernel: packages, the kernel, and compute.

​

Create a notebook

• Ask the agent. In any chat, ask for a notebook: “Build a notebook that tracks weekly signups by channel.” The agent creates it, adds cells, and runs them.
• Create one yourself. Open the workspace’s files and click New notebook. It opens with one empty cell.

​

Cells

• Python: any Python code.
• SQL: a query against a connection, or DuckDB over the notebook’s own data. See SQL and Python.
• Markdown: text, headings, and notes.

• Click Add a cell at the end of the notebook.
• Open a cell’s ⋯ menu and choose Insert cell above, Insert cell below, or one of the Insert Markdown and Insert SQL items.
• Select a cell and press A to insert above or B to insert below.

​

Build it with the agent

• Create notebooks, and add, edit, move, and delete cells.
• Run a cell, the whole notebook, the stale cells, or everything upstream or downstream of a cell.
• Read outputs, variables, and dataframes, and follow the dependency graph.
• Install packages and change notebook settings.
• Show any cell’s output, such as a table or chart, right in the chat.

​

Work together

• Avatars in the toolbar show who is in the notebook. Each cell shows who is editing it, and the agent appears as Alkera.
• Typing from several people in one cell merges as they type.
• Everyone shares one kernel, so everyone sees the same outputs. Each run records who ran it, such as “by Alkera agent for Alice”.
• A cell is not re-run automatically while someone is editing it.

​

The file format

# >>> alkera
# format = "1.0"
# dataframe = "polars"
# <<< alkera
import marimo
app = marimo.App()

with app.setup(alkera_id="0000000001"):
    import alkera

@app.cell(alkera_id="0000000002")
def _():
    orders = alkera.sql(
        rf"""
        SELECT * FROM analytics.orders
        """,
        connection="Snowflake prod",
    )
    return (orders,)

​

View and download

​

In this section