Python get_bigquery_data примеры использования

Пример #1

Файл: standard_deviation_analysis_BQ.py Проект: HadoopChampion930/dax_project

def update_result(table_store):
    storage = Storage(google_key_path='igenie-project-key.json')
    query = 'UPDATE `' + table_store +'` SET Status = "inactive" WHERE Status = "active"'

    try:
        result = storage.get_bigquery_data(query)
    except Exception as e:
        print(e) 

Пример #2

def update_result(table_store):
    storage = Storage(google_key_path=args.service_key_path)
    query = 'UPDATE `' + table_store + '` SET Status = "inactive" WHERE Status = "active"'

    try:
        result = storage.get_bigquery_data(query)
    except Exception as e:
        print(e)

Пример #3

def update_result(table_store):
    #storage = Storage(google_key_path='/Users/kefei/Documents/Igenie_Consulting/keys/igenie-project-key.json')
    storage = Storage(google_key_path='igenie-project-key.json')
    query = 'UPDATE `' + table_store + '` SET Status = "inactive" WHERE Status = "active"'

    try:
        result = storage.get_bigquery_data(query)
    except Exception as e:
        print(e)

Пример #4

Файл: Fundamental_ranking_BQ.py Проект: HadoopChampion930/dax_project

def update_result(table_store,choice):
    if choice == 1:
        table_store = 'pecten_dataset_test.Fundamental_current_ranking2'
    else:
        table_store = 'pecten_dataset_test.Fundamental_growth_ranking2'
    
    storage = Storage(google_key_path='/Users/kefei/Documents/Igenie_Consulting/keys/igenie-project-key.json')
    storage = Storage(google_key_path='igenie-project-key.json' )
    query = 'UPDATE `' + table_store +'` SET Status = "inactive" WHERE Status = "active"'

    try:
        result = storage.get_bigquery_data(query)
    except Exception as e:
        print(e) 

Пример #5

Файл: webscraping_analyst_BQ.py Проект: ariesocean/dax_project

def update_result(args):
    table_store = args.table_storage

    if args.environment == 'test':
        dataset = 'pecten_dataset_test'
    else:
        dataset = 'pecten_dataset'

    #storage = Storage(google_key_path='/Users/kefei/Documents/Igenie_Consulting/keys/igenie-project-key.json')
    storage = Storage(google_key_path=args.service_key_path)
    query = 'UPDATE `' + dataset + '.' + table_store + '` SET Status = "inactive" WHERE Status = "active"'

    try:
        result = storage.get_bigquery_data(query)
    except Exception as e:
        print(e)