- NAME
-
- gcloud alpha bq tables show-rows - display selected rows in a specified table or view
- SYNOPSIS
-
-
gcloud alpha bq tables show-rows
(--table
=TABLE
:--dataset
=DATASET
) [--limit
=LIMIT
; default=100] [--start
=START
] [GCLOUD_WIDE_FLAG …
]
-
- DESCRIPTION
-
(ALPHA)
Display selected rows in a specified table or view. - EXAMPLES
-
The following command displays 150 rows of
my-table
inmy-dataset
starting from row 10:gcloud alpha bq tables show-rows --table /projects/myproject/datasets/my-dataset/tables/my-table --limit 150 --start 10
- REQUIRED FLAGS
-
-
Table resource - The BigQuery table you want to fetch rows from. 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
--table
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.
--table
=TABLE
-
ID of the table or fully qualified identifier for the table.
To set the
table
attribute:-
provide the argument
--table
on the command line.
This flag argument must be specified if any of the other arguments in this group are specified.
-
provide the argument
--dataset
=DATASET
-
The id of the BigQuery dataset.
To set the
dataset
attribute:-
provide the argument
--table
on the command line with a fully specified name; -
provide the argument
--dataset
on the command line.
-
provide the argument
-
provide the argument
-
Table resource - The BigQuery table you want to fetch rows from. 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.
- OPTIONAL FLAGS
-
--limit
=LIMIT
; default=100- How many rows to return in the result.
--start
=START
- First row to return in the result.
- 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. - API REFERENCE
-
This command uses the
bigquery/v2
API. The full documentation for this API can be found at: https://cloud.google.com/bigquery/ - 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.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-02-06 UTC.