GoogleBigQueryLinkedService interface
Google BigQuery service linked service.
- Extends
Properties
additional |
A comma-separated list of public BigQuery projects to access. Type: string (or Expression with resultType string). |
authentication |
The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR. |
client |
The client id of the google application used to acquire the refresh token. Type: string (or Expression with resultType string). |
client |
The client secret of the google application used to acquire the refresh token. |
The service account email ID that is used for ServiceAuthentication and can only be used on self-hosted IR. Type: string (or Expression with resultType string). |
|
encrypted |
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string. |
key |
The full path to the .p12 key file that is used to authenticate the service account email address and can only be used on self-hosted IR. Type: string (or Expression with resultType string). |
project | The default BigQuery project to query against. Type: string (or Expression with resultType string). |
refresh |
The refresh token obtained from Google for authorizing access to BigQuery for UserAuthentication. |
request |
Whether to request access to Google Drive. Allowing Google Drive access enables support for federated tables that combine BigQuery data with data from Google Drive. The default value is false. Type: string (or Expression with resultType string). |
trusted |
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. Type: string (or Expression with resultType string). |
type | Polymorphic discriminator, which specifies the different types this object can be |
use |
Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false.Type: boolean (or Expression with resultType boolean). |
Inherited Properties
annotations | List of tags that can be used for describing the linked service. |
connect |
The integration runtime reference. |
description | Linked service description. |
parameters | Parameters for linked service. |
version | Version of the linked service. |
Property Details
additionalProjects
A comma-separated list of public BigQuery projects to access. Type: string (or Expression with resultType string).
additionalProjects?: any
Property Value
any
authenticationType
The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR.
authenticationType: string
Property Value
string
clientId
The client id of the google application used to acquire the refresh token. Type: string (or Expression with resultType string).
clientId?: any
Property Value
any
clientSecret
The client secret of the google application used to acquire the refresh token.
clientSecret?: SecretBaseUnion
Property Value
The service account email ID that is used for ServiceAuthentication and can only be used on self-hosted IR. Type: string (or Expression with resultType string).
email?: any
Property Value
any
encryptedCredential
The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string.
encryptedCredential?: string
Property Value
string
keyFilePath
The full path to the .p12 key file that is used to authenticate the service account email address and can only be used on self-hosted IR. Type: string (or Expression with resultType string).
keyFilePath?: any
Property Value
any
project
The default BigQuery project to query against. Type: string (or Expression with resultType string).
project: any
Property Value
any
refreshToken
The refresh token obtained from Google for authorizing access to BigQuery for UserAuthentication.
refreshToken?: SecretBaseUnion
Property Value
requestGoogleDriveScope
Whether to request access to Google Drive. Allowing Google Drive access enables support for federated tables that combine BigQuery data with data from Google Drive. The default value is false. Type: string (or Expression with resultType string).
requestGoogleDriveScope?: any
Property Value
any
trustedCertPath
The full path of the .pem file containing trusted CA certificates for verifying the server when connecting over SSL. This property can only be set when using SSL on self-hosted IR. The default value is the cacerts.pem file installed with the IR. Type: string (or Expression with resultType string).
trustedCertPath?: any
Property Value
any
type
Polymorphic discriminator, which specifies the different types this object can be
type: "GoogleBigQuery"
Property Value
"GoogleBigQuery"
useSystemTrustStore
Specifies whether to use a CA certificate from the system trust store or from a specified PEM file. The default value is false.Type: boolean (or Expression with resultType boolean).
useSystemTrustStore?: any
Property Value
any
Inherited Property Details
annotations
List of tags that can be used for describing the linked service.
annotations?: any[]
Property Value
any[]
Inherited From LinkedService.annotations
connectVia
The integration runtime reference.
connectVia?: IntegrationRuntimeReference
Property Value
Inherited From LinkedService.connectVia
description
Linked service description.
description?: string
Property Value
string
Inherited From LinkedService.description
parameters
Parameters for linked service.
parameters?: {[propertyName: string]: ParameterSpecification}
Property Value
{[propertyName: string]: ParameterSpecification}
Inherited From LinkedService.parameters
version
Version of the linked service.
version?: string
Property Value
string
Inherited From LinkedService.version