tBigQueryInput properties for Apache Spark Batch
These properties are used to configure tBigQueryInput running in the Spark Batch Job framework.
The Spark Batch tBigQueryInput component belongs to the Databases family.
The component in this framework is available in all Talend products with Big Data and Talend Data Fabric.
Basic settings
Source type |
Select the way you want tBigQueryInput to read data from Google
BigQuery:
|
Schema and Edit Schema |
A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. When you create a Spark Job, avoid the reserved word line when naming the fields. Click Edit schema to make changes to the schema. If the current schema is of the Repository type, three options are available:
|
|
Built-In: You create and store the schema locally for this component only. |
|
Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs. |
When the Source type is Table:
Project ID |
If your Google BigQuery service uses the Google Cloud Platform project ID, keep this check box clear to allow tBigQueryInput to read this ID from the Spark configuration tab or the tBigQueryConfiguration component. If the Google BigQuery service uses a custom ID, select this check box and enter the ID. The ID of your project can be found in the URL of the Google API Console, or by hovering your mouse pointer over the name of the project in the BigQuery Browser Tool. |
Dataset |
Enter the name of the dataset to which the table to be copied belongs. When you use Google BigQuery with Dataproc, in Google Cloud Platform, select the same region for your BigQuery dataset as for the Dataproc cluster to be run. |
Table |
Enter the name of the table to be copied. |
When the Source type is Query:
Query |
Enter the query to be used. When you use Google BigQuery with Dataproc, in Google Cloud Platform, select the same region for your BigQuery dataset as for the Dataproc cluster to be run. If the query to be used is the legacy SQL of BigQuery, select this Use legacy SQL check box. For further information about this legacy SQL, see Legacy SQL query reference from the Google BigQuery documentation. |
Usage
Usage rule |
This is an input component. It sends data extracted from BigQuery to the component that follows it. Place a tBigQueryConfiguration component in the same Job because it needs to use the BigQuery configuration information provided by tBigQueryConfiguration. |
Spark Connection |
In the Spark
Configuration tab in the Run
view, define the connection to a given Spark cluster for the whole Job. In
addition, since the Job expects its dependent jar files for execution, you must
specify the directory in the file system to which these jar files are
transferred so that Spark can access these files:
This connection is effective on a per-Job basis. |