List snapshots
You can list the snapshots created in your CDP environment against a COD database using the list-snapshots command. You can use different filters to list the snapshots, for example, table name, specific command ID, and time range.
Command syntax
cdp opdb list-snapshots --environment-name ENVIRONMENT_NAME --database-name DATABASE_NAME [--table-name TABLE_NAME] [--command-id COMMAND_ID] [--from-creation-time FROM_CREATION_TIME] [--to-creation-time TO_CREATION_TIME]
Parameters
- --environment-name
-
The name of the CDP environment.
- --database-name
-
The name of the operational database.
- --table-name
-
The fully qualified name of the HBase table whose snapshots are to be listed.
- --command-id
-
Command ID filter.
- --from-creation-time
-
The starting snapshot creation time to search snapshots (inclusive).
- --to-creation-time
-
The ending snapshot creation time to search snapshots (inclusive).
cdp opdb list-snapshots --environment-name odx-wgel6j --database-name test { "environmentName": "odx-wgel6j", "databaseName": "test", "snapshots": [ { "tableName": "table_tob8vc", "snapshotName": "snapshot3_table_tob8vc", "creationTime": 1662014265011, "status": "SUCCESSFUL", "commandID": 1546336058, "snapshotLocation": "abfs://qedailynat-filesystem@q.dfs.core.windows.net/hbase" }, { "tableName": "table_tob8vc", "snapshotName": "snapshot2_table_tob8vc", "creationTime": 1662014023725, "status": "SUCCESSFUL", "commandID": 1546336035, "snapshotLocation": "abfs://qedailynat-filesystem@q.dfs.core.windows.net/hbase" }, { "tableName": "table_tob8vc", "snapshotName": "snapshot1_table_tob8vc", "creationTime": 1662013782370, "status": "DELETED", "commandID": 1546336077, "snapshotLocation": "abfs://qedailynat-filesystem@q.dfs.core.windows.net/hbase" }, { "tableName": "table_lpirwy", "snapshotName": "snapshot_table_lpirwy", "creationTime": 1662013568312, "status": "DELETED", "commandID": 1546336004, "snapshotLocation": "abfs://qedailynat-filesystem@q.dfs.core.windows.net/hbase" } ] }With command ID filter:
cdp opdb list-snapshots --environment-name odx-wgel6j --database-name test --command-id 1546336385 { "environmentName": "odx-wgel6j", "databaseName": "test", "snapshots": [ { "tableName": "table_6uf7xt", "snapshotName": "s2", "creationTime": 1662035967244, "status": "SUCCESSFUL", "commandID": 1546336385, "snapshotLocation": "abfs://qedailynat-filesystem@qedailynatstorageaccount.dfs.core.windows.net/cod-rtzupxh843ua/hbase/" } ] }With table name filter:
cdp opdb list-snapshots --environment-name odx-wgel6j --database-name test --table-name table_6uf7xt { "environmentName": "odx-wgel6j", "databaseName": "test", "snapshots": [ { "tableName": "table_6uf7xt", "snapshotName": "s2", "creationTime": 0, "status": "SUCCESSFUL", "commandID": 1546336385, "snapshotLocation": "abfs://qedailynat-filesystem@qedailynatstorageaccount.dfs.core.windows.net/cod-rtzupxh843ua/hbase/" } ] }