GoogleBigQueryLinkedService interface

Google BigQuery service linked service.

Extends

Properties

additionalProjects

A comma-separated list of public BigQuery projects to access. Type: string (or Expression with resultType string).

authenticationType

The OAuth 2.0 authentication mechanism used for authentication. ServiceAuthentication can only be used on self-hosted IR.

clientId

The client id of the google application used to acquire the refresh token. Type: string (or Expression with resultType string).

clientSecret

The client secret of the google application used to acquire the refresh token.

email

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).

encryptedCredential

The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: 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).

project

The default BigQuery project to query against. Type: string (or Expression with resultType string).

refreshToken

The refresh token obtained from Google for authorizing access to BigQuery for UserAuthentication.

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).

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).

type

Polymorphic discriminator, which specifies the different types this object can be

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).

Inherited Properties

annotations

List of tags that can be used for describing the linked service.

connectVia

The integration runtime reference.

description

Linked service description.

parameters

Parameters for 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

email

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