How do you load data from a CSV file into BigQuery?

Question

Accepted Answer

Loading a CSV file to BigQuery can be done using the web UI, command line, or API.

Use the BigQuery web UI: Navigate to BigQuery, select your dataset, click 'Create Table', and upload your CSV file.
Command-line tool: Use the bq command with 'bq load' command. Example: bq load --source_format=CSV dataset.table gs://bucket/file.csv
Using Python client library: Use 'google-cloud-bigquery' to load CSV. Example: client.load_table_from_uri('gs://bucket/file.csv', 'dataset.table')
Ensure your CSV is properly formatted: Check for headers, delimiters, and data types to match BigQuery schema.

Interview Questions from Popular Companies