.TH "GCLOUD_BETA_SPANNER_DATABASES_CREATE" 1



.SH "NAME"
.HP
gcloud beta spanner databases create \- create a Cloud Spanner database



.SH "SYNOPSIS"
.HP
\f5gcloud beta spanner databases create\fR (\fIDATABASE\fR\ :\ \fB\-\-instance\fR=\fIINSTANCE\fR) [\fB\-\-async\fR] [\fB\-\-database\-dialect\fR=\fIDATABASE_DIALECT\fR] [\fB\-\-ddl\fR=\fIDDL\fR] [\fB\-\-ddl\-file\fR=\fIDDL_FILE\fR] [\fB\-\-proto\-descriptors\-file\fR=\fIPROTO_DESCRIPTORS_FILE\fR] [\fB\-\-kms\-keys\fR=[\fIKMS_KEYS\fR,...]\ |\ [\fB\-\-kms\-key\fR=\fIKMS_KEY\fR\ :\ \fB\-\-kms\-keyring\fR=\fIKMS_KEYRING\fR\ \fB\-\-kms\-location\fR=\fIKMS_LOCATION\fR\ \fB\-\-kms\-project\fR=\fIKMS_PROJECT\fR]] [\fIGCLOUD_WIDE_FLAG\ ...\fR]



.SH "DESCRIPTION"

\fB(BETA)\fR Create a Cloud Spanner database.



.SH "EXAMPLES"

To create an empty Cloud Spanner database, run:

.RS 2m
$ gcloud beta spanner databases create testdb \e
    \-\-instance=my\-instance\-id
.RE

To create a Cloud Spanner database with populated schema, run:

.RS 2m
$ gcloud beta spanner databases create testdb \e
    \-\-instance=my\-instance\-id \e
    \-\-ddl='CREATE TABLE mytable (a INT64, b INT64) PRIMARY KEY(a)'
.RE

To create a Cloud Spanner database with the PostgreSQL dialect, run:

.RS 2m
$ gcloud beta spanner databases create testdb \e
    \-\-instance=my\-instance\-id \-\-database\-dialect=POSTGRESQL
.RE



.SH "POSITIONAL ARGUMENTS"

.RS 2m
.TP 2m

Database resource \- The Cloud Spanner database to create. 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 \f5database\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
\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 \f5database\fR on the command line.
.RE
.sp

This positional 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 \f5database\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 "FLAGS"

.RS 2m
.TP 2m
\fB\-\-async\fR

Return immediately, without waiting for the operation in progress to complete.

.TP 2m
\fB\-\-database\-dialect\fR=\fIDATABASE_DIALECT\fR

The SQL dialect of the Cloud Spanner Database. GOOGLE_STANDARD_SQL is the
default. \fIDATABASE_DIALECT\fR must be one of: \fBPOSTGRESQL\fR,
\fBGOOGLE_STANDARD_SQL\fR.

.TP 2m
\fB\-\-ddl\fR=\fIDDL\fR

Semi\-colon separated DDL (data definition language) statements to run inside
the newly created database. If there is an error in any statement, the database
is not created. This option is not supported for the PostgreSQL dialect. Full
DDL specification is at
https://cloud.google.com/spanner/docs/data\-definition\-language

.TP 2m
\fB\-\-ddl\-file\fR=\fIDDL_FILE\fR

Path of a file that contains semi\-colon separated DDL (data definition
language) statements to run inside the newly created database. If there is an
error in any statement, the database is not created. This option is not
supported for the PostgreSQL dialect. Full DDL specification is at
https://cloud.google.com/spanner/docs/data\-definition\-language. If
\-\-ddl_file is set, \-\-ddl is ignored. One line comments starting with \-\-
are ignored.

.TP 2m
\fB\-\-proto\-descriptors\-file\fR=\fIPROTO_DESCRIPTORS_FILE\fR

Path of a file that contains a protobuf\-serialized
google.protobuf.FileDescriptorSet message. To generate it, install and run
\f5protoc\fR with \-\-include_imports and \-\-descriptor_set_out.

.TP 2m

KMS key name group

At most one of these can be specified:


.RS 2m
.TP 2m

Key resource \- Cloud KMS key(s) to be used to create the Cloud Spanner
database. This represents a Cloud resource. (NOTE) Some attributes are not given
arguments in this group but can be set in other ways.

To set the \f5kms\-project\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-kms\-keys\fR on the command line with a fully
specified name.
.RE
.sp

To set the \f5kms\-location\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-kms\-keys\fR on the command line with a fully
specified name.
.RE
.sp

To set the \f5kms\-keyring\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5\-\-kms\-keys\fR on the command line with a fully
specified name.
.RE
.sp


.RS 2m
.TP 2m
\fB\-\-kms\-keys\fR=[\fIKMS_KEYS\fR,...]

IDs of the keys or fully qualified identifiers for the keys.

To set the \f5kms\-key\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-kms\-keys\fR on the command line.
.RE
.sp

.RE
.sp
.TP 2m

Key resource \- Cloud KMS key to be used to create the Cloud Spanner database.
The arguments in this group can be used to specify the attributes of this
resource.


.RS 2m
.TP 2m
\fB\-\-kms\-key\fR=\fIKMS_KEY\fR

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

To set the \f5kms\-key\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-kms\-key\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\-\-kms\-keyring\fR=\fIKMS_KEYRING\fR

KMS keyring id of the key.

To set the \f5kms\-keyring\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-kms\-key\fR on the command line with a fully
specified name;
.IP "\(em" 2m
provide the argument \f5\-\-kms\-keyring\fR on the command line.
.RE
.sp

.TP 2m
\fB\-\-kms\-location\fR=\fIKMS_LOCATION\fR

Cloud location for the key.

To set the \f5kms\-location\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-kms\-key\fR on the command line with a fully
specified name;
.IP "\(em" 2m
provide the argument \f5\-\-kms\-location\fR on the command line.
.RE
.sp

.TP 2m
\fB\-\-kms\-project\fR=\fIKMS_PROJECT\fR

Cloud project id for the key.

To set the \f5kms\-project\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5\-\-kms\-key\fR on the command line with a fully
specified name;
.IP "\(em" 2m
provide the argument \f5\-\-kms\-project\fR on the command line.
.RE
.sp


.RE
.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 beta and might change without notice. These
variants are also available:

.RS 2m
$ gcloud spanner databases create
.RE

.RS 2m
$ gcloud alpha spanner databases create
.RE