Connect to your Google Big Query instance.

GoogleBigQueryReader Properties

  • sqlQuery (Inline Only): Google BigQuery dialect SQL statement to read data into Lingk
  • credential (Env First): The Google credential with permissions to the Google service.
  • projectId (Env First): The project Id from Google Developer Console.
Example with Environment Credentials
-
    name: myConnectorName
    type: GoogleBigQueryReader
    properties:
      sqlQuery:  Select * from xxx 
    #schemaRef: schemaName # optional from "schemas:"
Example with Inline Credentials
-
    name: myConnectorName
    type: GoogleBigQueryReader
    properties:
      sqlQuery: Select * from xxx 
      credential: jsonValue 
      projectId: my:project:id 
    #schemaRef: schemaName # optional from "schemas:"

GoogleBigQueryWriter Properties

  • credential (Env First): The Google credential with permissions to the Google service.
  • projectId (Env First): The project Id from Google Developer Console.
  • jobType (Inline Only): Options are batch and streaming. defaults to: batch
  • tableId (Inline Only): The Table ID to write data to.
Example with Environment Credentials
-
    name: myConnectorName
    type: GoogleBigQueryWriter
    properties:
      jobType:  batch  # optional 
      tableId:  myTable 

Example with Inline Credentials
-
    name: myConnectorName
    type: GoogleBigQueryWriter
    properties:
      credential:  jsonValue 
      projectId:  my:project:id 
      jobType:  batch  # optional 
      tableId:  myTable