john pfeiffer
  • Home
  • Categories
  • Tags
  • Archives

google bigquery

  1. download httplib2 (needed the newest)
  2. python setup.py install ( https://code.google.com/p/httplib2/ )
  3. download bq -> python setup.py install ( https://code.google.com/p/google-bigquery-tools/ )

    python bq.py

  4. prompted for OAuth login (URL for a browser to authenticate with your Google Account)

  5. paste the validation code into the command line console
  6. uses a default project
  7. show publicdata:samples.shakespeare

    query "SELECT word, count(word) as count FROM publicdata:samples.shakespeare WHERE word CONTAINS 'French' GROUP BY word"

    WITH YOUR BROWSER SEE THE DATA USAGE: https://code.google.com/apis/console/#project:395023946872:bigquery QUERY HISTORY: https://bigquery.cloud.google.com/queries/395023946872


  • « dictionary iteration iteritems viewkeys
  • java programming intro main static systemProperties »

Published

Apr 18, 2013

Category

python-appengine

~73 words

Tags

  • appengine 18
  • bigquery 1
  • google 18
  • python 180