Console

1. In the Google Cloud console, go to theBigQuery page.

   Go to BigQuery

2. In the left pane, clickexploreExplorer:

   

   If you don't see the left pane, clicklast_pageExpand left pane to open the pane.

3. In theExplorer pane, expand your project, clickDatasets, andthen click the dataset that has the table snapshot.

4. ClickOverview> Tables, and then click the name of thetable snapshot.

5. In the snapshot pane that appears, you can do the following:

   • Click theSchema tab to view the table snapshot's schema andpolicy tags.

   • Click theDetails table to view the table snapshot's size,expiration, base table, snapshot time, and other information.

SQL

To see metadata for a table snapshot, query theINFORMATION_SCHEMA.TABLE_SNAPSHOTS view:

1. In the Google Cloud console, go to theBigQuery page.

   Go to BigQuery

2. In the query editor, enter the following statement:

   SELECT*FROMPROJECT_ID.DATASET_NAME.INFORMATION_SCHEMA.TABLE_SNAPSHOTSWHEREtable_name='SNAPSHOT_NAME';

   Replace the following:

   • PROJECT_ID: the project ID of the project that contains the snapshot.
   • DATASET_NAME: the name of the dataset that contains the snapshot.
   • SNAPSHOT_NAME: the name of the snapshot.

3. Clickplay_circleRun.

For more information about how to run queries, seeRun an interactive query.

bq

Enter the following command in the Cloud Shell:

Go to Cloud Shell

bqshow\--format=prettyjson\PROJECT_ID:DATASET_NAME.SNAPSHOT_NAME

Replace the following:

• PROJECT_ID: the project ID of the project that contains the snapshot.
• DATASET_NAME: the name of the dataset that contains the snapshot.
• SNAPSHOT_NAME: the name of the snapshot.

The output is similar to the following:

{"creationTime":"1593194331936",..."snapshotDefinition":{"baseTableReference":{"datasetId":"myDataset","projectId":"myProject","tableId":"mytable"},"snapshotTime":"2020-06-26T17:58:50.815Z"},"tableReference":{"datasetId":"otherDataset","projectId":"myProject","tableId":"mySnapshot"},"type":"SNAPSHOT"}

API

Call thetables.getmethod with the following parameters:

The response body is similar to the following:

{  "kind": "bigquery#table",  "etag": "...",  "id": "myProject:myDataset.mySnapshot",  "selfLink": "https://content-bigquery.googleapis.com/bigquery/v2/projects/myProject/datasets/myDataset/tables/mySnapshot",  "tableReference": {    "projectId": "myProject",    "datasetId": "myDataset",    "tableId": "mySnapshot"  },  "description": "...",  "schema": {    "fields": [      ...    ]  },  "numBytes": "637931",  "numLongTermBytes": "0",  "numRows": "33266",  "creationTime": "1593194331936",  "lastModifiedTime": "1593194331936",  "type": "SNAPSHOT",  "location": "US",  "snapshotDefinition": {    "baseTableReference": {      "projectId": "myProject",      "datasetId": "otherDataset",      "tableId": "myTable"    },    "snapshotTime": "2020-06-26T17:58:50.815Z"  }}