Doorda Knowledge Base
Using Python Articles
Exporting Data from BigQuery with Python
Viewed 478 times since Fri, Aug 24, 2018
This article demonstrates how you can export data from BigQuery to your local machine or SQL database.   Querying Data from BigQuery: projectid = 'doorda-production-207313' query = 'SELECT * FROM YOUR_DATASET_ID.YOUR_TABLE_ID'... Read More
Listing Accessible Data on BigQuery with Python
Viewed 516 times since Thu, Aug 23, 2018
Before making a query, you might want to have an overview of all available data to you. This article will demonstrates how you can do so with BigQuery's Python API.   List Accessible Datasets Doorda Host consists of a wide range of datasets,... Read More
Calculating Usage Using Dry Run with Python
Viewed 298 times since Tue, Aug 28, 2018
What is Dry Run? Running queries on large dataset can be costly, therefore it is recommendation to conduct a dry run before querying. Dry run is the process of calculating usage for your query.   from google.cloud import bigquery client = bigquery... Read More
Getting Started on Doorda Host with Python
Viewed 461 times since Mon, Jun 25, 2018
This article will help you connect to BigQuery on Python and save the query result into a TSV file.    Dependencies 1)  gcloud cli Windows: https://cloud.google.com/sdk/docs/quickstart-windows Mac: https://cloud.google.com/sdk/docs/quickstart... Read More