BigQuery JSON schemas
To specify the column names and types for table in BigQuery JSON format, use:
--schema bigquery-schema:my_table.json
The file my_table.json
should be a BigQuery JSON schema file:
[
{
"name": "id",
"type": "INT64",
"mode": "REQUIRED"
},
{
"name": "name",
"type": "STRING",
"mode": "REQUIRED"
},
{
"name": "quantity",
"type": "INT64",
"mode": "REQUIRED"
}
]
Limitations
This schema format supports a small number of general types. For example, all integer types are represented as INT64
, all floating-point types are represented as FLOAT64
, and both JSON values and UUIDs are represented as STRING
.