PowerExchange for Google BigQuery User Guide for PowerCenter

Back Next

Pre-SQL and Post-SQL Commands

You can specify

pre SQL

and

post SQL

session properties for Google BigQuery sources and targets. When you create a Session task in the

Workflow Manager

, you can specify SQL commands on the

Mapping

tab.

You can perform the following operations by using pre SQL and post SQL commands:

SELECT

UPDATE

DELETE

You can configure the options in Google BigQuery with a pre SQL or post SQL statement in the

pre SQL Configuration

post SQL Configuration

session properties for Google BigQuery sources and targets.

You must use the following format to specify a pre SQL configuration or a post SQL configuration:

<Option1:Value1,Option2:Value2,...OptionN:ValueN>

The following table shows the configuration options and supported values that you can specify in a pre SQL configuration or post SQL configuration:

Options	Supported Values
DestinationDataset	Dataset ID in Google BigQuery
DestinationTable	Table name in Google BigQuery
FlattenResults	True and False
UseLegacySQL	True and False
WriteDisposition	WRITE_TRUNCATE, WRITE_APPEND, and WRITE_EMPTY