Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Google BigQuery
  3. PowerExchange for Google BigQuery Configuration
  4. Google BigQuery Sources and Targets
  5. Google BigQuery Mappings
  6. Google BigQuery Sessions
  7. Google BigQuery as CDC Target
  8. Google BigQuery Pushdown Optimization
  9. Appendix A: Google BigQuery Data Type Reference

PowerExchange for Google BigQuery User Guide for PowerCenter

PowerExchange for Google BigQuery User Guide for PowerCenter

Import a Google BigQuery Source Definition

Import a Google BigQuery Source Definition

To create a Google BigQuery source definition, use the Source Analyzer to import source metadata with the Google BigQuery ODBC data source.
  1. In the Source Analyzer, click
    Sources
    Import from Database.
  2. Select the Google BigQuery data source used to connect to the source database.
    If you need to create or modify a Google BigQuery data source, click the
    Browse
    button to open the ODBC Administrator. Create the Google BigQuery data source and click
    OK.
    Select the new Google BigQuery data source.
  3. Enter the user name and password to connect to Google BigQuery.
    Specify a dummy username and password.
  4. Click
    Connect.
    The following image shows the
    Import Tables
    dialog box where you can import a Google BigQuery source definition:
  5. Select a dataset and scroll down through the list of tables to find the source you want to import. Select the Google BigQuery table or tables you want to import.
    You can hold down the
    Shift
    key to select a block of sources within one folder or hold down the
    Ctrl
    key to make non-consecutive selections within a folder. You can also select all tables within a dataset by selecting the dataset and clicking
    Select All
    . Use the
    Select None
    button to clear all highlighted selections.
  6. Click
    OK.
The source definition appears in the Source Analyzer. In the Navigator, the source definition appears in the Sources node of the active repository folder under the source database name.

0 COMMENTS

We’d like to hear from you!