PowerExchange for Google BigQuery User Guide for PowerCenter

Back Next

Configure a Google BigQuery Source Definition Using a Custom SQL Query

You can configure a Google BigQuery source definition either by selecting the tables in the package explorer or by using a custom SQL query.

Start PowerCenter Designer and connect to a PowerCenter repository configured with a Google BigQuery instance.

Open a source folder.

Open the

Source Analyzer

, and then click

Sources

Create PowerExchange For BigQuery Source

The

Google BigQuery Connection Details

dialog box appears.

Add the connection details, and click

Finish

to add the connection.

Click

The

Select Objects from

tab appears.

Select the dataset in

Package Explorer

To configure a Google BigQuery source, select the source type:

Select

From Object

to select from the list of tables that you want to import, and then click

Import

The following image shows the list of tables that appear when you select the

From Object

source type:

Select

From Custom Query

to configure the source using a custom SQL query, and click

Import

The following image shows the configured custom query to import the tables: