/opt/iamguarded/google-cloud-sdk/bin/bq

Python script for interacting with BigQuery.


USAGE: bq.py [--global_flags] <command> [--command_flags] [args]



Global flags:

/usr/share/google-cloud-sdk/platform/bq/bq.py:
  --alpha: <none|query_max_slots>: 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: <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.
    (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 <command>' to get help for <command>.

Try --helpfull to get a list of all flags.