> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google BigQuery

export const CommonAuthSchemeAzureWorkloadIdentity = () => {
  return <>
      <p>To connect with single sign-on via PingFederate, specify the following properties:</p>
      <ul>
        <li><strong>Auth Scheme:</strong> Select <strong>AzureWorkloadIdentity</strong>.</li>
        <li>
          <strong>Azure Workload Identity Config:</strong> Enter a semicolon-separated list of <code>Key=Value</code> properties, as shown in this example:
          <p><code>{'AzureWorkloadIdentityConfig="AuthScheme=AzureServicePrincipal;AzureTenant=directory (tenant) id;OAuthClientID=application (client) id;OAuthClientSecret=client secret;AzureResource=application id uri;"'}</code></p>
          <p>Note that it is optional as to whether you want to include the value within quotes.</p>
        </li>
        <li><strong>Workload Pool Id:</strong> Enter The identifier (Id) of your Workload Identity Federation pool.</li>
        <li><strong>Workload Project Id:</strong> Enter the Id of the Google Cloud project that hosts your Workload Identity Federation pool.</li>
      </ul>
    </>;
};

export const CommonAuthSchemeAwsWorkloadIdentity = () => {
  return <>
      <p>To connect with single sign-on via PingFederate, specify the following properties:</p>
      <ul>
        <li><strong>Auth Scheme:</strong> Select <strong>AWSWorkloadIdentity</strong>.</li>
        <li>
          <strong>AWS Workload Identity Config:</strong> Enter a semicolon-separated list of <code>Key=Value</code> properties, as shown in this example:
          <p><code>{'AWSWorkloadIdentityConfig="AuthScheme=AwsRootKeys;AccessKey=\'AKIAABCDEF123456\';SecretKey=...;Region=us-east-1"'}</code></p>
          <p>Note that it is optional as to whether you want to include the value within quotes.</p>
        </li>
        <li><strong>Workload Pool Id:</strong> Enter The identifier (Id) of your Workload Identity Federation pool.</li>
        <li><strong>Workload Project Id:</strong> Enter the Id of the Google Cloud project that hosts your Workload Identity Federation pool.</li>
      </ul>
    </>;
};

export const CommonAuthSchemeGcpinstanceaccount = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>
        When you run {siteName} on a GCP virtual machine, {siteNameShort} can authenticate by using the service account that is tied to the virtual machine. Select <strong>GCPInstanceAccount</strong> for <strong>Auth Scheme</strong> to use that account. No additional properties are required.
      </p>
    </>;
};

export const CommonAuthSchemeOauthEmbedded = ({siteName = "CData Sync", siteNameShort = "Sync", datasource = "the data source"}) => {
  return <>
      <p>
        {siteName} provides an embedded OAuth application with which to connect. To use the application, select <strong>OAuth</strong> for <strong>Auth Scheme</strong>. No additional properties are required.
      </p>
    </>;
};

export const CommonDatasourceMoreInformation = ({datasource = "the data source", advancedurl = "", siteName = "CData Sync", driverVersion = ""}) => {
  return <>
      <p>
        For more information about interactions between {siteName} and {datasource}, see{' '}
        <a href={`https://cdn.cdata.com/help/${advancedurl}${driverVersion}/synch/default.htm`}>
          {datasource} Connector for {siteName}
        </a>.
      </p>
    </>;
};

export const CommonDatasourceAddConnector = ({datasource = "the data source", title = "the connector", destination = false, siteNameShort = "Sync"}) => {
  return <>
      <p>
        To enable {siteNameShort} to use data from {datasource}, you first must add the
        connector, as follows:
      </p>
      <ol>
        <li>Open the <strong>Connections</strong> page of the {siteNameShort} dashboard.</li>
        <li>Click <strong>Add Connection</strong> to open the <strong>Select Connectors</strong> page.</li>
        <li>
          Click the <strong>{destination ? "Destinations" : "Sources"}</strong> tab and locate
          the <strong>{title}</strong> row.
        </li>
        <li>
          Click the <strong>Configure Connection</strong> icon at the end of that row to open
          the <strong>New Connection</strong> page. This action opens the{' '}
          <strong>Add Connection</strong> dialog box.
          <br />
          <strong>Note:</strong> If the <strong>Configure Connection</strong> icon is not
          available, click the <strong>Download Connector</strong> icon to install
          the {title} connector.
        </li>
        <li>Enter a name for your connection in the <strong>Add Connection</strong> dialog box.</li>
        <li>Click <strong>Add</strong> to open the <strong>Settings</strong> tab for your connector.</li>
      </ol>
      <p>
        For more information about installing new connectors, see{' '}
        <a href="../connections">Connections</a>.
      </p>
    </>;
};

export const CommonDatasourceIntroSource = ({datasource = "the data source", siteName = "CData Sync"}) => {
  return <p>
      You can use the {datasource} connector from the {siteName} application to capture data
      from {datasource} and move it to any supported destination. To do so, you need to add
      the connector, authenticate to the connector, and complete your connection.
    </p>;
};

export const driverVersion = "M";

export const siteNameShort = "Sync";

export const siteName = "CData Sync";

export const datasource = "Google BigQuery";
export const pageTitle = "Google BigQuery";
export const advancedurl = "DB";
export const oauthschemes = "oauth";

<CommonDatasourceIntroSource datasource={datasource} siteName={siteName} />

## Add the Google BigQuery Connector

<CommonDatasourceAddConnector datasource={datasource} title={pageTitle} destination={false} siteNameShort={siteNameShort} />

## Authenticate to Google BigQuery

After you add the connector, you need to set the required properties.

{siteName} supports authenticating to {pageTitle} in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

* [**OAuth**](#oauth) (default)
* [**OAuth JWT**](#oauth-jwt)
* [**GCPInstanceAccount**](#gcp-instance-account)
* [**AWS Workload Identity**](#aws-workload-identity)
* [**Azure Workload Identity**](#azure-workload-identity)

### OAuth

<CommonAuthSchemeOauthEmbedded siteName={siteName} siteNameShort={siteNameShort} datasource={datasource} />

### OAuth JWT

To connect with a Google service account, specify the following properties:

* **Auth Scheme:** Select **OAuthJWT**.
* **OAuth JWT Cert:** Enter your Java web tokens (JWT) certificate store.
* **OAuth JWT Cert Type:** Enter the type of key store that contains your JWT Certificate. The default type is **GOOGLEJSONBLOB**.
* (Optional) **OAuth JWT Subject:** Enter the user subject for which the application is requesting delegated access.

### GCP Instance Account

<CommonAuthSchemeGcpinstanceaccount siteName={siteName} siteNameShort={siteNameShort} datasource={datasource} />

### AWS Workload Identity

<CommonAuthSchemeAwsWorkloadIdentity siteName={siteName} siteNameShort={siteNameShort} datasource={datasource} />

### Azure Workload Identity

<CommonAuthSchemeAzureWorkloadIdentity siteName={siteName} siteNameShort={siteNameShort} datasource={datasource} />

## Complete Your Connection

To complete your connection:

1. Specify the following settings:
   * **Project Id:** Enter the identifier of the project to which {siteNameShort} should connect.
   * (Optional) **Dataset Id:** Enter the identifier of the data set to which {siteNameShort} should connect.
2. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
3. {oauthschemes ? `If you authenticate with ${oauthschemes}, click` : "Click"} **Connect to {datasource}** to connect to your {pageTitle} account.
4. Click **Create & Test** to create your connection.

## More Information

<CommonDatasourceMoreInformation datasource={datasource} advancedurl={advancedurl} siteName={siteName} driverVersion={driverVersion} />