Skip to content

Google BigQuery

Configuration Steps

  • Select the main Studio button on the lower right corner of the dashboard to open the Providers dialog
  • Select New Data Provider
  • Select Google BigQuery
  • Enter the provider name
  • Enter your Google Cloud Project ID
  • The Client ID is defaulted to the built-in Google OAuth Client ID of ChartFactor Studio. Studio also gives you the option to use your own Google OAuth Client ID. This is completely optional, but you may want to do it if your organization has specific security or access requirements. The next section describes how to obtain your Client ID.
  • Change the other properties as needed

  • A picture of the data provider window with sample information is below.

    image

  • Click on the SAVE button. Scroll down within the dialog if the button is not visible.

  • Now select the newly created BigQuery Data Provider in the Data Providers window
  • Select Data Sources

If you are not authenticated to Google Cloud, you will be automatically redirected to the Google Sign-In page. After successfully signing in, you will be redirected back to ChartFactor Studio where you will be able to see your Google Cloud project's datasets and tables.

Obtaining a Google OAuth Client ID

The following steps describe how to obtain an OAuth 2.0 Client ID in your Google Cloud project.

  1. Navigate to the Google Cloud Console > APIs & Services > Credentials.
  2. Click Create Credentials and select OAuth client ID.
  3. Select Web application as the application type.
  4. In Authorized JavaScript origins, add the URL where you are accessing ChartFactor Studio (e.g., https://chartfactor.com).
  5. In Authorized redirect URIs, add the callback URL. This is your Studio URL appended with /oauth2callback (e.g., https://chartfactor.com/studio/oauth2callback).
  6. Click Create and copy your Client ID.