gcloud_alpha_spanner_rows_insert (1)

NAME

gcloud alpha spanner rows insert - insert a row in a Cloud Spanner database

SYNOPSIS

gcloud alpha spanner rows insert --data=[COLUMN_NAME=VALUE,...] --table=TABLE (--database=DATABASE : --instance=INSTANCE) [GCLOUD_WIDE_FLAG ...]

REQUIRED FLAGS

--data=[COLUMN_NAME=VALUE,...]

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

--table=TABLE

The Cloud Spanner table name.

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 [project] attribute: provide the argument [--database] on the command line with a fully specified name; provide the argument [--project] on the command line; set the property [core/project]. This must be specified.

--database=DATABASE

ID of the database or fully qualified identifier for the database. This flag must be specified if any of the other arguments in this group are specified.

--instance=INSTANCE

The Cloud Spanner instance for the database.

GCLOUD WIDE FLAGS

These flags are available to all commands: --account, --configuration, --flags-file, --flatten, --format, --help, --log-http, --project, --quiet, --trace-token, --user-output-enabled, --verbosity. Run $ gcloud help for details.

EXAMPLES

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

$ gcloud alpha spanner rows insert --table=Singers \
    --database=my-database --instance=my-instance \
    --data=SingerId=1,SingerName=abc

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

NOTES

This command is currently in ALPHA and may change without notice. If this command fails with API permission errors despite specifying the right project, you will have to apply for early access and have your projects registered on the API whitelist to use it. To do so, contact Support at cloud.google.com/support These variants are also available:

$ gcloud spanner rows insert $ gcloud beta spanner rows insert