This is BigQuery CLI 2.0.39

Python script for interacting with BigQuery. USAGE: bq [--global_flags] <command> [--command_flags] [args] Global flags: bq_auth_flags: --application_default_credential_file: Only for the gcloud wrapper use. (default: '') --credential_file: Only for the gcloud wrapper use. (default: '/home/samuel/.bigquery.v2.token') --service_account: Only for the gcloud wrapper use. (default: '') --service_account_credential_file: Only for the gcloud wrapper use. --service_account_private_key_file: Only for the gcloud wrapper use. (default: '') --service_account_private_key_password: Only for the gcloud wrapper use. (default: 'notasecret') --[no]use_gce_service_account: Only for the gcloud wrapper use. (default: 'false') bq_flags: --api: API endpoint to talk to. (default: 'https://www.googleapis.com') --api_version: API version to use. (default: 'v2') --apilog: Log all API requests and responses to the file specified by this flag. Also accepts "stdout" and "stderr". Specifying the empty string will direct to stdout. --bigqueryrc: Path to configuration file. The configuration file specifies new defaults for any flags, and can be overrridden by specifying the flag on the command line. If the --bigqueryrc flag is not specified, the BIGQUERYRC environment variable is used. If that is not specified, the path "~/.bigqueryrc" is used. (default: '/home/samuel/.bigqueryrc') --ca_certificates_file: Location of CA certificates file. (default: '') --dataset_id: Default dataset reference to use for requests (Ignored when not applicable.). Can be set as "project:dataset" or "dataset". If project is missing, the value of the project_id flag will be used. (default: '') --[no]debug_mode: Show tracebacks on Python exceptions. (default: 'false') --[no]disable_ssl_validation: Disables HTTPS certificates validation. This is off by default. (default: 'false') --discovery_file: Filename for JSON document to read for discovery. (default: '') --[no]enable_gdrive: When set to true, requests new OAuth token with GDrive scope. When set to false, requests new OAuth token without GDrive scope. --[no]fingerprint_job_id: Whether to use a job id that is derived from a fingerprint of the job configuration. This will prevent the same job from running multiple times accidentally. (default: 'false') --format: <none|json|prettyjson|csv|sparse|pretty>: Format for command output. Options include: pretty: formatted table output sparse: simpler table output prettyjson: easy-to-read JSON format json: maximally compact JSON csv: csv format with header The first three are intended to be human-readable, and the latter three are for passing to another program. If no format is selected, one will be chosen based on the command run. --[no]headless: Whether this bq session is running without user interaction. This affects behavior that expects user interaction, like whether debug_mode will break into the debugger and lowers the frequency of informational printing. (default: 'false') --httplib2_debuglevel: Instruct httplib2 to print debugging messages by setting debuglevel to the given value. --job_id: A unique job_id to use for the request. If not specified, this client will generate a job_id. Applies only to commands that launch jobs, such as cp, extract, load, and query. --job_property: Additional key-value pairs to include in the properties field of the job configuration; repeat this option to specify a list of values --location: Default geographic location to use when creating datasets or determining where jobs should run (Ignored when not applicable.) --max_rows_per_request: Specifies the max number of rows to return per read. (an integer) --project_id: Default project to use for requests. (default: '') --proxy_address: The name or IP address of the proxy host to use for connecting to GCP. (default: '') --proxy_password: The password to use when authenticating with proxy host. (default: '') --proxy_port: The port number to use to connect to the proxy host. (default: '') --proxy_username: The user name to use when authenticating with proxy host. (default: '') -q,--[no]quiet: If True, ignore status updates while jobs are running. (default: 'false') -sync,--[no]synchronous_mode: If True, wait for command completion before returning, and use the job completion status for error codes. If False, simply create the job, and use the success of job creation as the error code. (default: 'true') --trace: A tracing token of the form "token:<token>" to include in api requests. google.apputils.app: -?,--[no]help: show this help --[no]helpshort: show usage only for this module --[no]helpxml: like --help, but generates XML output --[no]run_with_pdb: Set to true for PDB debug mode (default: 'false') --[no]run_with_profiling: Set to true for profiling the script. Execution will be slower, and the output format might change over time. (default: 'false') --[no]show_build_data: show build data and exit --[no]use_cprofile_for_profiling: Use cProfile instead of the profile module for profiling. This has no effect unless --run_with_profiling is set. (default: 'true') gflags: --flagfile: Insert flag definitions from the given file into the command line. (default: '') --undefok: comma-separated list of flag names that it is okay to specify on the command line even if the program does not define a flag with that name. IMPORTANT: flags in this list that have arguments MUST use the --flag=value format. (default: '') Run 'bq help' to see the list of available commands. Run 'bq help <command>' to get help for <command>.