to_dataframe( create_bqstorage_client=True, ) ) dataframe from_service_account_file(key_path, scopes=,) bqclient = bigquery.Client(credentials=credentials, project=credentials.project_id,) # Download query results: query = """ SELECT date, country_name, subregion1_name, subregion2_name, new_confirmed, new_deceased, new_recovered, new_tested, cumulative_confirmed, cumulative_deceased, cumulative_recovered,cumulative_tested FROM `vid19_open_vid19_open_data` WHERE country_name = 'Australia' AND subregion1_name IN ('Victoria','New South Wales') Limit 10 """ dataframe = ( bqclient.query(query).
from google.cloud import bigquery from google.oauth2 import service_account key_path = "" credentials = service_account\. Note you will have to enter the path to your keyfile.
When you have your project and key file for this project ready to go, the following code will authenticate the connection and then run a query to check that it is working on this specific database.
0 kommentar(er)
