Inserting and Modifying Data using the Console

The Google Cloud Platform Console provides an interface for inserting, editing, and deleting data in a Cloud Spanner table.

Finding your table

To get started, open a table of Cloud Spanner data in the GCP Console.

  1. Go to the Cloud Spanner page in the GCP Console.
    Go to the Spanner page
  2. Click the name of an instance.
  3. In the left panel of the instance details page, click the name of a database.

    Screenshot of databases listed in left pane

  4. Under Tables, click the name of a table.

    Screenshot of tables listed in database detail page

  5. On the table details page, click the Data tab.

    Screenshot of table details page

You can insert, edit, and delete table rows in this tab. See below for detailed instructions.

Inserting data

  1. On the Data tab of the table details page, click Insert.
  2. Enter the values you want to insert.

    • To set a field to <NULL>, leave the field blank.
    • To set a STRING field to an empty string, check empty string.
    • BYTES values cannot be viewed or edited in the console. Instead, use a client library.

    See Data Types for more information about available types and their properties.

  3. Click Save.

    The GCP Console displays the data from your table, including the inserted row.

Editing data

  1. On the Data tab of the table details page, select the row you want to edit, then click Edit.

    Need help finding a row? Type its primary key into the filter box.

  2. Edit the values, then click Save.

    The GCP Console displays the data from your table, including the modified row.

Deleting data

  1. On the Data tab of the table details page, select one or more rows you wish to delete, then click Delete.

    Need help finding a row? Type its primary key into the filter box.

  2. In the dialog that appears after you click Delete, click OK.

    The GCP Console displays the data from your table, which no longer contains the deleted rows.

For an interactive example of inserting and modifying data in a Cloud Spanner table, see the Quickstart Using the Console.

Was this page helpful? Let us know how we did:

Send feedback about...

Cloud Spanner Documentation