Skip to content

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.

License

Notifications You must be signed in to change notification settings

wintermi/bq2csv

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

84 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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.

About

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.

Topics

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages