Batch load data from a specific file in formats such as CSV, JSON, Parquet, and Avro to a table

bq

  • The bq command-line tool is a Python-based command-line tool for BigQuery.
    More information: <https://cloud.google.com/bigquery/docs/reference/bq-cli-reference>.
  • Trick copyright: tl;dr; <https://github.com/tldr-pages/tldr>

bq load --location={{location}} --source_format={{CSV|JSON|PARQUET|AVRO}} {{dataset}}.{{table}} {{path_to_source}}

click the source code to copy