Hi Matt:
So, Python is a great language to use with BigQuery API - as is Ruby, Java, JavaScript, and others as well!
If you already have Python installed on your machine, the two tools I would suggest getting to know are:
- gsutil - a command line tool for interacting with Google Cloud Storage, written in Python
- bq - the BigQuery command line client, also written in Python
Both of these open source tools are great for getting started uploading raw data into Cloud Storage, and then ingesting that data and running queries in BigQuery.
When you are ready to write more of your own code, I would suggest getting a hold of the
Google Python API client library. This library helps you simplify interacting with the BigQuery API, as well as other Google APIs, via Python.
The
BigQuery Developer's guide has tons of Python code samples to check out as well. For a complete sample of almost everything you can do with the BigQuery API and Python, check out the
source code to the bq tool.
- Michael