Package version:

Interface GoogleBigQueryLinkedService

Google BigQuery service linked service.

interface GoogleBigQueryLinkedService {
    additionalProjects?: any;
    annotations?: any[];
    authenticationType: string;
    clientId?: any;
    clientSecret?: SecretBaseUnion;
    connectVia?: IntegrationRuntimeReference;
    description?: string;
    email?: any;
    encryptedCredential?: string;
    keyFilePath?: any;
    parameters?: {
        [propertyName: string]: ParameterSpecification;
    };
    project: any;
    refreshToken?: SecretBaseUnion;
    requestGoogleDriveScope?: any;
    trustedCertPath?: any;
    type: "GoogleBigQuery";
    useSystemTrustStore?: any;
    version?: string;
}

Hierarchy (view full)

Properties

additionalProjects? annotations? authenticationType clientId? clientSecret? connectVia? description? email? encryptedCredential? keyFilePath? parameters? project refreshToken? requestGoogleDriveScope? trustedCertPath? type useSystemTrustStore? version?

Properties

OptionaladditionalProjects

additionalProjects?: any

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

Optionalannotations

annotations?: any[]

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

authenticationType

authenticationType: string

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

OptionalclientId

clientId?: any

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

OptionalclientSecret

clientSecret?: SecretBaseUnion

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

OptionalconnectVia

connectVia?: IntegrationRuntimeReference

The integration runtime reference.

Optionaldescription

description?: string

Linked service description.

Optionalemail

email?: any

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

OptionalencryptedCredential

encryptedCredential?: string

The encrypted credential used for authentication. Credentials are encrypted using the integration runtime credential manager. Type: string.

OptionalkeyFilePath

keyFilePath?: any

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

Optionalparameters

parameters?: {
    [propertyName: string]: ParameterSpecification;
}

Parameters for linked service.

project

project: any

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

OptionalrefreshToken

refreshToken?: SecretBaseUnion

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

OptionalrequestGoogleDriveScope

requestGoogleDriveScope?: any

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

OptionaltrustedCertPath

trustedCertPath?: any

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

type

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

OptionaluseSystemTrustStore

useSystemTrustStore?: any

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

Optionalversion

version?: string

Version of the linked service.

Settings

Member Visibility