/bq2csv

A command line application designed to provide a simple method to execute a BigQuery SQL script from "stdin", outputting all results to "stdout" in CSV format. A detailed log is output to the console "stderr" providing you with the available execution statistics.

Primary LanguageGoApache License 2.0Apache-2.0

BigQuery 2 CSV

Workflows Go Report License Release

Description

A command line application designed to provide a simple method to execute a BigQuery SQL script from "stdin", outputting all results to "stdout" in CSV format. A detailed log is output to the console "stderr" providing you with the available execution statistics.

USAGE:
    bq2csv -p PROJECT_ID -d DATASET

ARGS:
  -c	Disable Query Cache
  -d string
    	BigQuery Dataset  (Required)
  -dr
    	Dry Run
  -f string
    	Field Delimter (default ",")
  -l string
    	BigQuery Data Processing Location
  -p string
    	Google Cloud Project ID  (Required)
  -v	Output Verbose Detail

Example

echo "SELECT 1" | bq2csv -p PROJECT_ID -d DATASET 1> results.csv

License

bq2csv is released under the Apache License 2.0 unless explicitly mentioned in the file header.