Skip to main content
Properties for BigQuery connections are specified in the properties object when creating or updating a connection. All properties are nested within the connection request body.

​
Properties

​
authType
string
required
Authentication type for BigQuery. Currently only private_key is supported.
​
projectId
string
required
GCP project ID where your BigQuery datasets are located.
​
dataset
string
required
Default dataset where Prophecy will write data.
​
serviceAccountKey
object
required
Reference to a Prophecy secret containing the service account key JSON.
  • When using the create connection API, the secret must be stored in Prophecy before creating the connection.
  • When using the create fabric API, replace this whole object with the string {{SECRET}}, which references the secret being created in parallel to the connection.