Preface
Introduction to PowerExchange for Google BigQuery
PowerExchange for Google BigQuery Configuration
- PowerExchange for Google BigQuery Configuration Overview
- Registering the PowerExchange for Google BigQuery Plug-in
  - Registering the PowerExchange for Google BigQuery Plug-in from the Administrator Tool
  - Registering the PowerExchange for Google BigQuery Plug-in from the Command Line Program
Google BigQuery Sources and Targets
Google BigQuery Mappings
- Google BigQuery Mappings Overview
- Source Filter
  - Configuring a Source Filter
Google BigQuery Sessions
Google BigQuery as CDC Target
Google BigQuery Pushdown Optimization
Appendix A: Google BigQuery Data Type Reference
- Data Type Reference Overview
- Google BigQuery and Transformation Data Types

PowerExchange for Google BigQuery User Guide for PowerCenter

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7

Back Next

Configuring Pass-through Partitioning for a Google BigQuery Session

Configure pass-through partitioning for a Google BigQuery session. After you add the number of partitions, you can specify a filter override condition for each of the partitions. Alternatively, you can specify a SQL override query instead of a filter override condition for each of the partitions. When you configure pass-through partitioning, you can also specify a different staging file directory for each of the partitions.

In the

Workflow Designer

, open the session properties.

In the

Partitions

view, click

Add Partition Point

The transformation name appears under the

Partition Points

node.

The image shows the Partitions view where you can configure Pass Through partitions

Select the Source transformation, and click

Edit Partition Point

The

Edit Partition Point

dialog box appears.

Click

Add

to add the partitions and enter a description for each partition.

Select the partition type as

Pass Through

for each of the partitions.

Click

Click the

Transformations

tab in the session properties.

Based on the number of partitions you create, those many number of partition fields appear for the

Filter Override

Local Staging File Directory

SQL Override Query

, and

Use Legacy SQL for SQL override

property.

Specify the filter override condition for each partition.

For example, in the following image, you can configure filter override conditions for each of the four partitions configured:

You can view the staging file directory and filter override condition set for each partition.

You can also specify local staging file directory for each of the partitions. If you do not specify a local staging file directory for a partition, the PowerCenter Integration Service considers the default staging file directory.

For example, in the following image, you can configure local staging file directory for each of the four partitions configured:

You can view the filter override condition set for each partition.

Rename Saved Search

Table of Contents

PowerExchange for Google BigQuery User Guide for PowerCenter

PowerExchange for Google BigQuery User Guide for PowerCenter

Configuring Pass-through Partitioning for a Google BigQuery Session

Configuring Pass-through Partitioning for a Google BigQuery Session