LittleBigQuery

LittleBigQuery is a Python module to simplify access to Google Big Query. It provides:

• Database-style commands for
  • Creating and dropping tables
  • Appending data
  • Describing tables and partitions
• Results as Pandas DataFrames
• Time-partitioning of existing tables with a TIMESTAMP column

Usage:

from little_big_query import *

bq = LittleBigQuery(<yourProjectId>, <datasetId>)

panda_frame = bq.query("SELECT emp FROM dep;")

bq.createTableFromCSV("myTable", [("col1","INTEGER"), ("col2", "STRING)], "gs://myBucket/myDirectory/*")

bq.desc("myTable") `

Installation with virtualenv

If you haven't yet, pip install virtualenv

virutalenv lqb

source activate lqb/bin/activate

cd little_big_query

python setup.py install