gcloud spanner rows insert

NAME
gcloud spanner rows insert - insert a row in a Cloud Spanner database
SYNOPSIS
gcloud spanner rows insert--data=[COLUMN_NAME=VALUE,…]--table=TABLE(--database=DATABASE :--instance=INSTANCE)[GCLOUD_WIDE_FLAG …]
EXAMPLES
To insert a row with SingerId=1,SingName=abc in table Singers under my-databaseand my-instance, run:
gcloudspannerrowsinsert--table=Singers--database=my-database--instance=my-instance--data=SingerId=1,SingerName=abc
gcloudspannerrowsinsert--table=Singers--database=my-database--instance=my-instance--flags-file=path/to/file.yaml
REQUIRED FLAGS
--data=[COLUMN_NAME=VALUE,…]
The column names and values for the row being added. For complicated inputvalues, such as arrays, use the--flags-file flag. See $gcloud topic flags-file formore information.
--table=TABLE
The Cloud Spanner table name.
Database resource - The Cloud Spanner database in which to insert a row. Thearguments in this group can be used to specify the attributes of this resource.(NOTE) Some attributes are not given arguments in this group but can be set inother ways.

To set theproject attribute:

  • provide the argument--database on the command line with a fullyspecified name;
  • provide the argument--project on the command line;
  • set the propertycore/project.

This must be specified.

--database=DATABASE
ID of the database or fully qualified identifier for the database.

To set thedatabase attribute:

  • provide the argument--database on the command line.

This flag argument must be specified if any of the other arguments in this groupare specified.

--instance=INSTANCE
The Cloud Spanner instance for the database.

To set theinstance attribute:

  • provide the argument--database on the command line with a fullyspecified name;
  • provide the argument--instance on the command line;
  • set the propertyspanner/instance.
GCLOUD WIDE FLAGS
These flags are available to all commands:--access-token-file,--account,--billing-project,--configuration,--flags-file,--flatten,--format,--help,--impersonate-service-account,--log-http,--project,--quiet,--trace-token,--user-output-enabled,--verbosity.

Run$gcloud help for details.

NOTES
These variants are also available:
gcloudalphaspannerrowsinsert
gcloudbetaspannerrowsinsert

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026-02-18 UTC.