.TH "GCLOUD_ALPHA_SPANNER_ROWS_INSERT" 1



.SH "NAME"
.HP
gcloud alpha spanner rows insert \- insert a row in a Cloud Spanner database



.SH "SYNOPSIS"
.HP
\f5gcloud alpha spanner rows insert\fR \fB\-\-data\fR=[\fICOLUMN_NAME\fR=\fIVALUE\fR,...] \fB\-\-table\fR=\fITABLE\fR (\fB\-\-database\fR=\fIDATABASE\fR\ :\ \fB\-\-instance\fR=\fIINSTANCE\fR) [\fIGCLOUD_WIDE_FLAG\ ...\fR]



.SH "EXAMPLES"

To insert a row with SingerId=1,SingName=abc in table Singers under my\-database
and my\-instance, run:

.RS 2m
$ gcloud alpha spanner rows insert \-\-table=Singers \e
    \-\-database=my\-database \-\-instance=my\-instance \e
    \-\-data=SingerId=1,SingerName=abc
.RE

.RS 2m
$ gcloud alpha spanner rows insert \-\-table=Singers \e
    \-\-database=my\-database \-\-instance=my\-instance \e
    \-\-flags\-file=path/to/file.yaml
.RE



.SH "REQUIRED FLAGS"

.RS 2m
.TP 2m
\fB\-\-data\fR=[\fICOLUMN_NAME\fR=\fIVALUE\fR,...]

The column names and values for the row being added. For complicated input
values, such as arrays, use the \f5\-\-flags\-file\fR flag. See $ gcloud topic
flags\-file for more information.

.TP 2m
\fB\-\-table\fR=\fITABLE\fR

The Cloud Spanner table name.

.TP 2m

Database resource \- The Cloud Spanner database in which to insert a row. The
arguments 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 in
other ways.

To set the \f5project\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-database\fR on the command line with a fully
specified name;
.IP "\(em" 2m
provide the argument \f5\-\-project\fR on the command line;
.IP "\(em" 2m
set the property \f5core/project\fR.
.RE
.sp

This must be specified.


.RS 2m
.TP 2m
\fB\-\-database\fR=\fIDATABASE\fR

ID of the database or fully qualified identifier for the database.

To set the \f5database\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-database\fR on the command line.
.RE
.sp

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

.TP 2m
\fB\-\-instance\fR=\fIINSTANCE\fR

The Cloud Spanner instance for the database.

To set the \f5instance\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-database\fR on the command line with a fully
specified name;
.IP "\(bu" 2m
provide the argument \f5\-\-instance\fR on the command line;
.IP "\(bu" 2m
set the property \f5spanner/instance\fR.
.RE
.sp


.RE
.RE
.sp

.SH "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 \fB$ gcloud help\fR for details.



.SH "NOTES"

This command is currently in alpha and might change without notice. If this
command fails with API permission errors despite specifying the correct project,
you might be trying to access an API with an invitation\-only early access
allowlist. These variants are also available:

.RS 2m
$ gcloud spanner rows insert
.RE

.RS 2m
$ gcloud beta spanner rows insert
.RE