You can use BigQuery Connector stage in the DataStage jobs to read data from the tables
in the BigQuery data warehouse or write data into the tables in the BigQuery data warehouse in the
specific contexts in which the jobs are designed.
Procedure
-
Importing BigQuery metadata.
-
Define a job that includes the BigQuery
Connector.
-
Define a connection to BigQuery.
-
To set up the BigQuery Connector to read data from BigQuery data warehouse, complete the
following steps
-
Configure the BigQuery Connector as a
source.
-
Set up column definitions on output link (Source).
-
To set up the BigQuery Connector stage to write data to BigQuery data warehouse, complete the
following steps
-
Configure the BigQuery Connector as a
target.
-
Set up column definitions on output link.
-
Compile and run the job.