Python Client for BigQuery Data Transfer API (Alpha)#

BigQuery Data Transfer API: Transfers data from partner SaaS applications to Google BigQuery on a scheduled, managed basis.

Quick Start#

In order to use this library, you first need to go through the following steps:

  1. Select or create a Cloud Platform project.
  2. Enable the BigQuery Data Transfer API.
  3. Setup Authentication.

Installation#

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.

Mac/Linux#

pip install virtualenv
virtualenv <your-env>
source <your-env>/bin/activate
<your-env>/bin/pip install google-cloud-bigquerydatatransfer

Windows#

pip install virtualenv
virtualenv <your-env>
<your-env>\Scripts\activate
<your-env>\Scripts\pip.exe install google-cloud-bigquerydatatransfer

Preview#

DataTransferServiceClient#

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, options=CallOptions(page_token=INITIAL_PAGE)):
    for element in page:
        # process element
        pass

Next Steps#