.TH "GCLOUD_ALPHA_BQ_TABLES_INSERT" 1



.SH "NAME"
.HP
gcloud alpha bq tables insert \- insert records specified into an existing table



.SH "SYNOPSIS"
.HP
\f5gcloud alpha bq tables insert\fR (\fITABLE\fR\ :\ \fB\-\-dataset\fR=\fIDATASET\fR) \fB\-\-data\fR=\fIPATH_TO_FILE\fR [\fIGCLOUD_WIDE_FLAG\ ...\fR]



.SH "DESCRIPTION"

\fB(ALPHA)\fR Insert records specified into an existing table.



.SH "EXAMPLES"

The following command inserts rows from \f5data_file.json\fR into
\f5my\-table\fR in \f5my\-dataset\fR:

.RS 2m
$ gcloud alpha bq tables insert \e
    \-\-table \e
    /projects/myproject/datasets/my\-dataset/tables/my\-table \e
    \-\-data data_file.json
.RE



.SH "POSITIONAL ARGUMENTS"

.RS 2m
.TP 2m

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 \f5project\fR attribute:
.RS 2m
.IP "\(em" 2m
provide the argument \f5table\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
\fITABLE\fR

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

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

The id of the BigQuery dataset.

To set the \f5dataset\fR attribute:
.RS 2m
.IP "\(bu" 2m
provide the argument \f5table\fR on the command line with a fully specified
name;
.IP "\(bu" 2m
provide the argument \f5\-\-dataset\fR on the command line.
.RE
.sp


.RE
.RE
.sp

.SH "REQUIRED FLAGS"

.RS 2m
.TP 2m
\fB\-\-data\fR=\fIPATH_TO_FILE\fR

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

.RS 2m
.IP "\(em" 2m
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}, ]
.RE
.sp

Use a full or relative path to a local file containing the value of data.


.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 "API REFERENCE"

This command uses the \fBbigquery/v2\fR API. The full documentation for this API
can be found at: https://cloud.google.com/bigquery/



.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.