Python script for interacting with BigQuery. USAGE: bq.py [--global_flags] [--command_flags] [args] Global flags: /usr/share/google-cloud-sdk/platform/bq/bq.py: --alpha: : Specifies an alpha feature to enable.; repeat this option to specify a list of values (default: '') --api: API endpoint to talk to. (default: 'https://bigquery.googleapis.com') --api_version: API version to use. (default: 'v2') --apilog: Log all API requests and responses to the file or directory specified by this flag. Also accepts "stdout" and "stderr". Specifying the empty string will direct to stdout. --bigquery_discovery_api_key: API key to use for discovery doc requests. --bigqueryrc: Path to configuration file. The configuration file specifies new defaults for any flags, and can be overridden 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: '/tmp/.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 the base BigQuery API discovery, excluding Model, Routine, RowAccessPolicy, and IAMPolicy APIs. (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. Unless authenticated with a service account, to use this flag, the use_google_auth flag must be set to false. (default: 'true') --[no]enable_resumable_uploads: Enables resumable uploads over HTTP for jobs that load data from local files. --[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: : 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. (an integer) --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 --[no]jobs_query_use_request_id: If true, sends request_id in jobs.query request. (default: 'false') --[no]jobs_query_use_results_from_response: If true, results from jobs.query response are used. (default: 'true') --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) --[no]mtls: If set to true, uses an mTLS client certificate on connections to BigQuery. (default: 'false') --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') --request_reason: Specifies a reason for making a request that is recorded in audit logs. -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 to include in api requests. --universe_domain: The universe domain to use in TPC domains. --[no]use_gcloud_config: If true, use gcloud config to override default flag values. (default: 'true') --[no]use_gcloud_config_cache: If true, use a persistent cache for gcloud config and credentials. (default: 'false') --[no]use_lep: Use a LEP endpoint based on the operation's location. (default: 'false') --[no]use_regional_endpoints: Use a regional endpoint based on the operation's location. (default: 'false') --[no]use_rep: Use a REP endpoint based on the operation's location. (default: 'false') Run 'bq.py help' to see the list of available commands. Run 'bq.py help ' to get help for . Try --helpfull to get a list of all flags.