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

Rules and Guidelines for Functions in Pushdown Optimization

Use the following rules and guidelines when you push functions to a Google BigQuery database:

To push the ADD_TO_DATE() function to the Google BigQuery database, you must define the arguments of the Date data type.

To push the GET_DATE_PART() function to the Google BigQuery database, you must define the arguments of the Date, DateTime, or Timestamp data type.

To push the INSTR() function to the Google BigQuery database, you must use the following format:

INSTR(string, search_value)

To push the IS_DATE() or LAST_DAY() function to the Google BigQuery database, you must define the arguments of the Date data type.

To push the function to the Google BigQuery database, you must define the arguments of the Date data type.

To push the MAX() function to the Google BigQuery database, you must define the arguments of the Number data type.

To push the MIN() function to the Google BigQuery database, you must define the arguments of the Date, Number, or String data type.

To push the ROUND(DATE) function to the Google BigQuery database, you must define the arguments of the Timestamp data type in the following format:

DDD

HH24

To push the TRUNC(DATE) function to the Google BigQuery database, you must define the arguments of the Timestamp data type in the following format:

YYY

YYYY

MON

DDD

HH24

To push the TO_CHAR(DATE) function to the Google BigQuery database, you must define the arguments of the Timestamp data type in the following format:

YYYY

HH24

;

"text"

When you define arguments of the Timestamp data type in the TO_DATE() function, you must use the following format:

YYYY

HH24

;

When you define arguments of the Timestamp data type in the GET_DATE_PART() function, you must use the following format:

YYY

YYYY

MON

DDD

HH24

When you push the TO_DATE() function to the Google BigQuery database, you must map the output to a Timestamp column in the Google BigQuery table.

When you push the SYSTIMESTAMP() function to the Google BigQuery database, do not specify any format. The Google BigQuery database returns the complete timestamp.

Ensure that you do not specify an in-out parameter of Date or Time data type. Otherwise, the session fails.

If the schema or table name starts with a number, then you must enclose the schema name or table name within single quotation marks.

When you configure the Lookup Source Filter or Lookup SQL Override property in a Lookup transformation, you must select the

Allow Temporary View for Pushdown

property under the session properties.

When you configure the

Allow Temporary View for Pushdown

in the session, you must have the bigquery.tables.create and bigquery.tables.delete to permissions create and drop views.

Rename Saved Search

Table of Contents

PowerExchange for Google BigQuery User Guide for PowerCenter

PowerExchange for Google BigQuery User Guide for PowerCenter

Rules and Guidelines for Functions in Pushdown Optimization

Rules and Guidelines for Functions in Pushdown Optimization