Labels

Apache Hadoop (3) ASP.NET (2) AWS S3 (2) Batch Script (3) BigQuery (21) BlobStorage (1) C# (3) Cloudera (1) Command (2) Data Model (3) Data Science (1) Django (1) Docker (1) ETL (7) Google Cloud (5) GPG (2) Hadoop (2) Hive (3) Luigi (1) MDX (21) Mongo (3) MYSQL (3) Pandas (1) Pentaho Data Integration (5) PentahoAdmin (13) Polybase (1) Postgres (1) PPS 2007 (2) Python (13) R Program (1) Redshift (3) SQL 2016 (2) SQL Error Fix (18) SQL Performance (1) SQL2012 (7) SQOOP (1) SSAS (20) SSH (1) SSIS (42) SSRS (17) T-SQL (75) Talend (3) Vagrant (1) Virtual Machine (2) WinSCP (1)

Monday, June 13, 2016

Install Google BigQuery - Command Line Tool


Google BigQuery can also be accessed from command line. To achieve this one need to implement below steps:


  1. Install Google cloud using, gcloud install by opening the terminal
  2. Check python version -- type python -version
  3. Run apt-get install python-setuptools
  4. Check if pip is installed, If not found, sudo easy_install pip
  5. Install google client tools for python using, pip install --upgrade google-api-python-client .
If not installed try the following commands (only for Mac users)
    1. Enter the following at a command prompt:
    2. $ curl https://sdk.cloud.google.com | bash
    3. Restart your shell:
    4. $ exec -l $SHELL
    5. Run gcloud init to initialize the gcloud environment:
    6. $ gcloud init
6. Initialise gcloud using , gcloud init
7. Check big query using bq command, bq ls

No comments:

Post a Comment