bq
Verified for current stable LTS
Bq Command: Batch Load Data From A File In Various Formats To A Table
Use for Batch load data from a file in various formats to a table with Bq. Exact CLI syntax to Batch load data from a file in various formats to a table using Bq.
When to use this: Use for Batch load data from a file in various formats to a table with Bq.
Command Syntax
bq load --location <location> --source_format <CSV|JSON|PARQUET|AVRO> <dataset>.<table> <path/to/source>bq load --location <location> --source_format <CSV|JSON|PARQUET|AVRO> <dataset>.<table> <path/to/source>Command Breakdown
--location- Command Option
- Tool-specific option used by this command invocation.
--source_format- Command Option
- Tool-specific option used by this command invocation.
FAQ
Purpose: Exact syntax to Batch load data from a file in various formats to a table using Bq.
Test path: Replace placeholders and run destructive commands in a disposable workspace first.
Flag behavior: Tool version, platform, and shell can change behavior.
Improve This Command
Suggest a correction, safer default, or version-specific note for this entry.
Related Operations
Bq Command: Copy A Table To Another Table Within The Same Dataset
bq cp <dataset>.<OLD_TABLE> <dataset>.<new_table> Bq Command: Create A New Dataset Or Table In A Specified Location bq mk --location=US <dataset_name>.<table_name> Bq Command: Display Help For Bq Commands bq help Bq Command: List All Datasets In A Project With Filters bq ls --filter labels.<key>:<value> --max_results <integer> --format=prettyjson --project_id <project_id> Bq Command: Run A Parameterized Query In BigQuery bq query --use_legacy_sql=false --parameter='ts_value:TIMESTAMP:2016-12-07 08:00:00' 'SELECT TIMESTAMP_ADD(@ts_value, INTERVAL 1 HOUR)'