.TH "GCLOUD_ALPHA_METASTORE_SERVICES_QUERY\-METADATA" 1



.SH "NAME"
.HP
gcloud alpha metastore services query\-metadata \- execute a SQL query against a Dataproc Metastore Service's metadata



.SH "SYNOPSIS"
.HP
\f5gcloud alpha metastore services query\-metadata\fR (\fISERVICE\fR\ :\ \fB\-\-location\fR=\fILOCATION\fR) \fB\-\-query\fR=\fIQUERY\fR [\fB\-\-format\fR=\fIFORMAT\fR] [\fIGCLOUD_WIDE_FLAG\ ...\fR]



.SH "DESCRIPTION"

\fB(ALPHA)\fR Execute a SQL query against a Dataproc Metastore Service's
metadata.



.SH "EXAMPLES"

To query metadata against a Dataproc Metastore service with the name
\f5my\-metastore\-service\fR in location \f5us\-central1\fR, and the sql query
"show tables;", run:

.RS 2m
$ gcloud alpha metastore services query\-metadata \e
    my\-metastore\-service \-\-location=us\-central1 \e
    \-\-query="show tables;"
.RE



.SH "POSITIONAL ARGUMENTS"

.RS 2m
.TP 2m

Service resource \- The service to query metadata. 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 \f5service\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
\fISERVICE\fR

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

To set the \f5service\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5service\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\-\-location\fR=\fILOCATION\fR

Location to which the service belongs.

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


.RE
.RE
.sp

.SH "REQUIRED FLAGS"

.RS 2m
.TP 2m
\fB\-\-query\fR=\fIQUERY\fR

Use Google Standard SQL query for Cloud Spanner and MySQL query syntax for Cloud
SQL. Cloud Spanner SQL is described at
https://cloud.google.com/spanner/docs/query\-syntax)"


.RE
.sp

.SH "COMMONLY USED FLAGS"

.RS 2m
.TP 2m
\fB\-\-format\fR=\fIFORMAT\fR

Sets the format for printing command output resources. The default is a
command\-specific human\-friendly output format. If both \f5core/format\fR and
\f5\-\-format\fR are specified, \f5\-\-format\fR takes precedence.
\f5\-\-format\fR and \f5core/format\fR both take precedence over
\f5core/default_format\fR. The supported formats are limited to: \f5config\fR,
\f5csv\fR, \f5default\fR, \f5diff\fR, \f5disable\fR, \f5flattened\fR, \f5get\fR,
\f5json\fR, \f5list\fR, \f5multi\fR, \f5none\fR, \f5object\fR, \f5table\fR,
\f5text\fR, \f5value\fR, \f5yaml\fR. For more details run $ gcloud topic
formats. Run \f5$ gcloud config set \-\-help\fR to see more information about
\f5core/format\fR


.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 metastore services query\-metadata
.RE

.RS 2m
$ gcloud beta metastore services query\-metadata
.RE