gcloud_alpha_bq_tables_insert (1)

NAME

gcloud alpha bq tables insert - insert records specified into an existing table

SYNOPSIS

gcloud alpha bq tables insert (TABLE : --dataset=DATASET) --data=DATA [GCLOUD_WIDE_FLAG ...]

DESCRIPTION

(ALPHA) Insert records specified into an existing table.

POSITIONAL ARGUMENTS

Table resource - The BigQuery table you want to insert data into. 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

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

--dataset=DATASET

The id of the BigQuery dataset.

REQUIRED FLAGS

--data=DATA

The file containing the newline-delimited array of JSON objects representing rows to insert.

---

For example: [ {"string_col": "value1", "bool_col": false}, {"string_col": "value2", "bool_col": true}, {"string_col": "value3", "bool_col": false}, {"string_col": "value4", "bool_col": true}, {"string_col": "value5", "bool_col": false}, ]

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 inserts rows from data_file.json into my-table in my-dataset:

$ gcloud alpha bq tables insert \
    --table \
    /projects/myproject/datasets/my-dataset/tables/my-table \
    --data data_file.json

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