Time Travel Queries

When adding data to Splitgraph via an upload, through a managed data source or by writing to the DDN, Splitgraph gives each new version a tag of the format YYYYMMDD-HHMMSS, as well as a tag with the format YYYYMMDD (latest version for a given day).

This lets you query older versions of a dataset by adding the tag to the repository name. For example:

SELECT * FROM "some/repo:latest".some_table;
SELECT * FROM "some/repo:20250412-163648".some_table;
SELECT * FROM "some/repo:20250412".some_table;

You can also run JOIN operations between different versions of the same dataset: