Add unique identifiers to your tables

How it works

What it covers

• Create tables with auto-generated UUID primary keys
• Add UUID columns to existing tables
• Generate UUIDs with uuid7()

What it uses

Install

terminal

$pip install pixeltable

Pixeltable calls

uuid.uuid7()pxt.create_table()insert()add_computed_column()

A look at the code

# Create table with auto-generated UUID primary key
products = pxt.create_table(
    'uuid_demo/products',
    {
        'id': uuid7(),  # Auto-generates UUID for each row
        'name': pxt.String,
        'price': pxt.Float,
    },
    primary_key=['id'],
)

One cell of the notebook, copied as it is. Open it in Colab for the rest.

• Join tables to combine data

  Combine data from multiple tables using inner, left, and cross joins.

  Updated Apr 10, 2026Open in Colab

• Track changes and revert to previous versions

  Undo mistakes, audit changes, and create point-in-time snapshots of your data.

  Updated Jun 13, 2026Open in Colab

• Create custom aggregate functions (UDAs)

  Build reusable aggregation logic for group-by queries and analytics.

  Updated Jan 24, 2026Open in Colab

• Custom Iterators

  An iterator in Pixeltable is a function that expands a single input row into multiple output rows.

  Updated Apr 10, 2026Open in Colab