Setting up Python Virtual Environment

Follow below steps to create a virtual environment with python 2.7 version, 

you can replace it with any other version.

    $ pip install virtualenv
    $ virtualenv -p python2.7 mypython27

   Run below command to activate python 2.7 virtualenv

   > Go to mypython27 directory
   $ . bin/activate

Determining _PARTITION details in BigQuery Partitioned Table

Run below query to check the partition summary of Bigquery table:

SELECT DATE(_PARTITIONDATE) AS PT, DATE(CURRENT_TIMESTAMP()) , DATE(DATE_ADD(CURRENT_TIMESTAMP(), -1, 'DAY'))
FROM [ProjectId:Dataset.Table]
GROUP BY PT

SELECT project_id, dataset_id, table_id, partition_id
, MSEC_TO_TIMESTAMP(creation_time) Created_date, MSEC_TO_TIMESTAMP(last_modified_time) modified_time
from [ProjectId:Dataset.Table$__PARTITIONS_SUMMARY__]