To configure the BigQuery connector to read rows from a BigQuery table, you must specify
the source table and other properties required.
Procedure
-
From the job design canvas, double-click the BigQuery
Connector stage.
- Use one of these methods to specify the source of the data:
- 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.
- Set Generate SQL at runtime to No, and then
specify the Select statement in the Select statement
property.
-
Optionally, you can specify Row limit and Byte
limit properties.
-
Click OK, and then save the job.