The BigQuery Data Transfer API allows users to transfer data from partner SaaS applications to Google BigQuery on a scheduled, managed basis.
In order to use this library, you first need to go through the following steps:
- Select or create a Cloud Platform project.
- Enable the BigQuery Data Transfer API.
- Setup Authentication.
Install this library in a virtualenv using pip. virtualenv is a tool to create isolated Python environments. The basic problem it addresses is one of dependencies and versions, and indirectly permissions.
With virtualenv, it's possible to install this library without needing system install permissions, and without clashing with the installed system dependencies.
Python >= 3.5
Python == 2.7. Python 2.7 support will be removed on January 1, 2020.
pip install virtualenv virtualenv <your-env> source <your-env>/bin/activate <your-env>/bin/pip install google-cloud-bigquery-datatransfer
pip install virtualenv virtualenv <your-env> <your-env>\Scripts\activate <your-env>\Scripts\pip.exe install google-cloud-bigquery-datatransfer
from google.cloud import bigquery_datatransfer_v1 client = bigquery_datatransfer_v1.DataTransferServiceClient() parent = client.location_path('[PROJECT]', '[LOCATION]') # Iterate over all results for element in client.list_data_sources(parent): # process element pass # Or iterate over results one page at a time for page in client.list_data_sources(parent).pages: for element in page: # process element pass
- Read the Client Library Documentation for BigQuery Data Transfer API API to see other available methods on the client.
- Read the Product documentation to learn more about the product and see How-to Guides.