Modeling Guide for SAP Data Hub

Google BigQuery SQL Consumer

Google BigQuery SQL Consumer (com.sap.dh.ds.dbq.sql.consumer) is based on system.externalOperator and uses datahub-flowagent for execution.

Configuration Parameters

Parameter

Type

Description

Google BigQuery Connection object The object containing the connection parameters to a Google BigQuery database.
Project ID (type string)
Google BigQuery Project ID.
Keyfile (type string)
Google BigQuery Account Key File.
Native SQL string SQL statement which will be used to read from the source. The syntax depends on the underlying source.

Input

Input

Type

Description

inSQL

string

SQL statement which will be used to read from the source. The syntax depends on the underlying source.

Output

Output

Type

Description

outConfig

string.flowagent.config

Flowagent type port, which only Flowagent producers can consume (i.e., Flowagent File Producer).

outError

string

Operator error. If mapped, the operator error will be sent to the operator this port is mapped to and the graph will remain running. If not mapped, the graph will terminate with the operator error.