SHOW SNAPSHOTS

Use the SHOW SNAPSHOTS command to list the snapshots for an iceberg table in a datalake database.

Syntax

Syntax for showing SNAPSHOTS:

SHOW SNAPSHOTS FOR <tablename>

Inputs

The SHOW SNAPSHOTS command has no inputs.

Privileges

You must be the admin user, the database owner, or you must have a privilege that allows you to connect to the current database.

Usage

SHOW SNAPSHOTS FOR PRODUCT:

     SNAPSHOT_ID     |   SNAPSHOT_TIMESTAMP
---------------------+-------------------------
 9200563116884920042 | 2023-11-22 14:07:11.568
  772896300100219109 | 2023-11-22 14:07:23.075
 6627427340973491406 | 2023-11-22 14:07:30.401
 5580047607422801480 | 2023-11-22 14:07:36.699
 9177117635666586877 | 2023-12-01 12:07:53.511
(5 rows)