Track changes and revert to previous versions

What it covers

• View version history with history() and get_versions()
• Access specific versions with pxt.get_table('table:N')
• Undo changes with revert()
• Create point-in-time snapshots with pxt.create_snapshot()

What it uses

Install

terminal

$pip install pixeltable

Pixeltable calls

pxt.create_table()pxt.create_snapshot()insert()add_computed_column()update()revert()

A look at the code

# Create table (version 0)
products = pxt.create_table(
    'version_demo/products',
    {'name': pxt.String, 'price': pxt.Float, 'category': pxt.String},
)

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

• 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

• Split data into multiple rows with iterators

  Transform a single document, video, image, or audio file into multiple rows for granular processing.

  Updated Jun 3, 2026Open in Colab

• Time Zones

  Because typical use cases involve datasets that span multiple time zones, Pixeltable strives to be precise in how it handles time zone arithmetic for datetimes.

  Updated Jan 24, 2026Open in Colab