tBigQueryConfiguration properties for Apache Spark Streaming - 7.1

Google BigQuery

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Cloud storages > Google BigQuery components
Data Quality and Preparation > Third-party systems > Cloud storages > Google BigQuery components
Design and Development > Third-party systems > Cloud storages > Google BigQuery components
EnrichPlatform
Talend Studio

These properties are used to configure tBigQueryConfiguration running in the Spark Streaming Job framework.

The Spark Streaming tBigQueryConfiguration component belongs to the Storage and the Databases families.

This component is available in Talend Real Time Big Data Platform and Talend Data Fabric.

Basic settings

When you use this component with Google Dataproc:

BigQuery temp GCS path

Enter the directory on Google Storage to temporarily store the data to be used with Google BigQuery. If not existing yet, this directory is created on the fly but the bucket that contains this directory must already exist. The syntax of the directory should be gs://my_bucket/my_directory.

When you use BigQuery with Dataproc, in Google Cloud Platform, select the same region for your Google BigQuery dataset as for the Dataproc cluster to be run.

Location

Select one of the Google multi-regional locations in which you want to read or write data. The resource dataset and the target dataset must be in the same location.

In Spark Jobs, only the US and the EU locations are supported.

For further information about Google locations and how to properly use the locations, see Dataset Locations from Google documentation.

When you use this component with the other distributions

Project identifier

Enter the ID of your Google Cloud Platform project.

If you are not certain about your project ID, check it in the Manage Resources page of your Google Cloud Platform services.

Path to Google Credentials file

Enter the path to the credentials file associated to the user account to be used. This file must be stored in the machine in which your Talend Job is actually launched and executed.

If you use Talend Jobserver to run your Job, store the credentials file not only in the machine of the Jobserver, in which the Job is launched, but also in the worker machines of the Spark cluster, in which the Job is executed; if you do not use the Jobserver, store the credentials file in your local machine from which you launch the Job and in the worker machines of the Spark cluster.

Use P12 credentials file format

When the Google credentials file to be used is in P12 format, select this check box and then in the Service account Id field that is displayed, enter the ID of the service account for which this P12 credentials file has been created.

BigQuery temp GCS path

Enter the directory on Google Storage to temporarily store the data to be used with Google BigQuery. If not existing yet, this directory is created on the fly but the bucket that contains this directory must already exist. The syntax of the directory should be gs://my_bucket/my_directory.

When you use BigQuery with Dataproc, in Google Cloud Platform, select the same region for your Google BigQuery dataset as for the Dataproc cluster to be run.

Location

Select one of the Google multi-regional locations in which you want to read or write data. The resource dataset and the target dataset must be in the same location.

In Spark Jobs, only the US and the EU locations are supported.

For further information about Google locations and how to properly use the locations, see Dataset Locations from Google documentation.

Usage

Usage rule

This component is used standalone in a subJob to provide connection configuration to Google BigQuery and Google Storage for the whole Job.

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:
  • Yarn mode (Yarn client or Yarn cluster):
    • When using Google Dataproc, specify a bucket in the Google Storage staging bucket field in the Spark configuration tab.

    • When using HDInsight, specify the blob to be used for Job deployment in the Windows Azure Storage configuration area in the Spark configuration tab.

    • When using Altus, specify the S3 bucket or the Azure Data Lake Storage for Job deployment in the Spark configuration tab.
    • When using Qubole, add a tS3Configuration to your Job to write your actual business data in the S3 system with Qubole. Without tS3Configuration, this business data is written in the Qubole HDFS system and destroyed once you shut down your cluster.
    • When using on-premise distributions, use the configuration component corresponding to the file system your cluster is using. Typically, this system is HDFS and so use tHDFSConfiguration.

  • Standalone mode: use the configuration component corresponding to the file system your cluster is using, such as tHDFSConfiguration or tS3Configuration.

    If you are using Databricks without any configuration component present in your Job, your business data is written directly in DBFS (Databricks Filesystem).

This connection is effective on a per-Job basis.