Configuring the BigQuery connector as a source

To configure the BigQuery connector to read rows from a BigQuery table, you must specify the source table and other properties required.

Procedure

  1. From the job design canvas, double-click the BigQuery Connector stage.
  2. Use one of these methods to specify the source of the data:
    1. Set Generate SQL at runtime to Yes, then enter the name of the source table or view in the Table name property. Set the name of the schema or dataset in Schema name property. Set the name of the Google project id where the source table resides, in the Database name property.
    2. Set Generate SQL at runtime to No, and then specify the Select statement in the Select statement property.
  3. Optionally, you can specify Row limit and Byte limit properties.
  4. Click OK, and then save the job.