Preface
Introduction to PowerExchange for Google BigQuery
- PowerExchange for Google BigQuery Overview
- Introduction to Google BigQuery
PowerExchange for Google BigQuery Configuration
- PowerExchange for Google BigQuery Configuration Overview
- Prerequisites
Configuring HTTP Proxy Options
- Configuring HTTP Proxy Options for the Mercury Client
- Configuring HTTP Proxy Options for the Data Integration Service
Google BigQuery Connections
PowerExchange for Google BigQuery Data Objects
PowerExchange for Google BigQuery Mappings
- PowerExchange for Google BigQuery Mappings Overview
- Mapping Validation and Run-time Environments
Google BigQuery Lookup
Google BigQuery Run-Time Processing
Appendix A: Google BigQuery Data Type Reference
- Data Type Reference Overview
- Google BigQuery and Transformation Data Types

PowerExchange for Google BigQuery User Guide

10.5.6
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0

Back Next

Creating a Google BigQuery Target

You can create a Google BigQuery target using the

Create Target

option. PowerExchange for Google BigQuery creates the data object write operation for the Google BigQuery data object.

Select a project or folder in the

Object Explorer

view.

Select a source or a transformation in the mapping.

Delete the FileName port from the

Ports

properties of the data object read operation and save.

If you do not want to delete the FileName port, you must add a transformation and map the fields to the Source transformation. Then, right-click on the transformation and select

Create Target

option to create a Google BigQuery target.

Right-click on the Source transformation or the transformation and select

Create Target

The

Create Target

dialog box appears.

Select

Others

and then select

Google BigQuery

from the list in the

Data Object Type

section.

Select

Link ports by name

as the

Link Type

Click

The

New Google BigQuery Data Object

dialog box appears.

Enter a name for the data object.

On the

Advanced

tab, set the following properties for the Google BigQuery data object write operation:

Property	Value
Dataset ID	Provide a Google BigQuery dataset name.
Create Disposition	Select Create If Needed .
Target Schema Strategy	Select Retain

Click

Finish

The new target appears under the

Physical Data Objects

category in the project or folder in the

Object Explorer

view.

You must specify a connection for the newly created Google BigQuery target in the

Connection

field to run a mapping.

PowerExchange for Google BigQuery Data Objects

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange for Google BigQuery User Guide

PowerExchange for Google BigQuery User Guide

Creating a Google BigQuery Target

Creating a Google BigQuery Target