|
<< Click to Display Table of Contents >> Raynet One Data Hub > 14.0 u1 > Connectors > Alphabetic Connector List > Google Cloud BigQuery > Connector Parameters Configuration |
This parameter contains the Project ID of the requested dataset.
Technical Name |
project_id |
Category |
Functional |
Type |
String |
Default Value |
n/a |
Example Values |
|
Select the query that will be executed in the GC BigQuery. The connector works only with primitive types, so the query must be written using the primitive (unnested) types, or all flattening must be done inside the query.
Technical Name |
required_ci_fields |
Category |
Functional |
Type |
Array null |
Default Value |
null |
Example Values |
SELECT project.id, billing_account_id FROM `{projectId}.{datasetName}.{tableName}`; SELECT id,name FROM `{projectId}.{datasetName}.{tableName}`; SELECT service.id, word_count FROM bigquery-public-data.samples.shakespeare limit 100; |
In order to fetch values from the 'project' object, it is possible to write it as 'project.id', project.name, etc.