Skip to contents

List available snapshots for a table

Source: R/time_travel.R
list_table_snapshots.Rd

Retrieves information about available snapshots/versions for a table.

Usage

list_table_snapshots(table_name = NULL, ducklake_name = NULL, conn = NULL)

Arguments

table_name

The name of the table to query

ducklake_name

The name of the ducklake (database) to query. If NULL, will attempt to infer from current database.

conn

Optional DuckDB connection object. If not provided, uses the default ducklake connection.

Value

A data frame with snapshot information (version, timestamp, etc.)

Details

This function queries the snapshot history of a table, showing available versions and their timestamps. This is useful for understanding what historical versions are available for time-travel queries.

See also

Other time travel: get_ducklake_table_asof(), get_ducklake_table_version(), get_table_changes(), restore_table_version()

Examples

if (FALSE) { # \dontrun{
# List all snapshots for a table
list_table_snapshots("my_table")
} # }