analyticsfromGC.py

from google.cloud import bigquery
import datetime



CLIENT = bigquery.Client.from_service_account_json(
    "credentials/****.json")
DATA_SETS = list(CLIENT.list_datasets())
print(DATA_SETS)


development_data_set = None
for data_set in DATA_SETS:
    if data_set.dataset_id == "analytics_188981975":
        print(data_set)
        development_data_set = data_set
        break


def initiate_analytics():
    
    input_date = str(datetime.datetime.strftime(
        datetime.datetime.now() - datetime.timedelta(1), '%Y%m%d'))

    print("Getting data for date: " + input_date)

    table_name = 'events_' + input_date
    print(table_name)

    query = """
        SELECT * FROM `%s.%s.%s` WHERE platform = 'ANDROID' and
        app_info.id = 'com.tarkalabs.firebaseanalytics'""" % (development_data_set.project,
                                                              development_data_set.dataset_id,
                                                              table_name)
    return CLIENT.query(query).result()