gcloud_alpha_bq_tables_show-rows (1)
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.
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. This flag must be
specified if any of the other arguments in this group are specified.
- --dataset=DATASET
-
The id of the BigQuery dataset.
- 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.
-
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: --account, --configuration, --flags-file, --flatten, --format, --help, --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: cloud.google.com/bigquery
EXAMPLES
The following command displays 150 rows of my-table in my-dataset starting from row 10:
-
$ gcloud alpha bq tables show-rows \
--table \
/projects/myproject/datasets/my-dataset/tables/my-table \
--limit 150 --start 10
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