Strategy One

Import Data from Google BigQuery (Native API)

Create an OAuth App in Google

  1. Sign in to https://console.cloud.google.com/apis/credentials.

  2. Click APIs & Services > Credentials > Create credentials.

  3. Choose OAuth client ID.

  4. In Application Type, choose Web application.

  5. Type an application name and click Save.

  6. Copy Client ID and Client secrets which you will use to create your Google BigQuery data source.

  7. Under Authorized redirect URIs, click Add URI and add the callback URL for Web, Library, or Workstation using the following formats:

    • Web redirect URI: https://<servername>/MicroStrategy/servlet/mstrWeb?evt=3172

    • Library redirect URI: https://<servername>/MicroStrategyLibrary/auth/DIOAuthRedirect.jsp

    • Workstation redirect URI: http://127.0.0.1

  8. Click Save.

Create a Google BigQuery (Native API) Data Source

Prior to Strategy (June 2026), you need to configure the Client ID and Client Secret that Google BigQuery provides in Strategy Web or configure the Client ID and Client Secret in Workstation. For more information, see Create an IAM Object with a Generic OAuth Type.

Starting in Strategy (June 2026), you can create multiple Salesforce Reports data sources.

Privileges

To create and edit authentication services, you must have the Configure security settings privilege.

To create and edit data sources, you must have the Create and edit database instances and connections privileges.

Create an Authentication Service in Workstation

  1. Open the Workstation window.

  2. In the Navigation pane, click , next to Enterprise Security.
  3. Choose an environment.
  4. From the identity provider drop-down, choose Google.

  5. Enter the Client ID and Client Secret that you noted as Consumer Key and Consumer Secret above.

    The Library Web, Authoring Web, and Workstation URIs automatically populate.

  6. Click Save.

Create Google BigQuery (Native API) Data Source

Starting in Strategy (June 2026), you can create multiple Salesforce data sources.

  1. If you are using Library:

    1. Click Create New and choose Dashboard.

    2. Click New Data.

    3. Click Create a new data source.

  2. If you are using Workstation, click next to Data Sources.

  3. Choose Google BigQuery Native.

  4. Type a Name and optional Description.

  5. Expand Default Database Connection and choose an existing database connection or click Add Database Connection and enter values in the required fields.

  6. To create a new database connection, choose the authentication service you created in Create an Authentication Service in Workstation or create a new one.

  7. Click Save.

Import Data

After you create a database role, you can import data.

  1. If you are using Workstation:

    1. Open the Workstation window.

    2. In the Navigation pane, click , next to Datasets.

    3. Select your environment and project.

    4. Choose Data Import Cube and click OK.

  2. If you are using Library, click Create New and choose Dashboard.

  3. Choose the Google BigQuery (Native API) database role.

    If this is your first time using the database role, a pop-up displays to login to Google.

  4. Your Google BigQuery projects and tables display in the left pane.

  5. Expand folders to view their tables.

  6. To refresh the contents of your Google account, click Refresh.

  7. If you need to access files in a different account, hover over the Google account under Services in Strategy, click Sign Out, and log in to the account.

  8. You can import Google BigQuery (Native API) data using the following methods:

    1. Import data with tables:

      1. In the left pane, expand the Google BigQuery (Native API) project you want to use.

      2. Hover over a table and click add to add it to the right pane.

    2. Import data with Freeform SQL:

      1. In the left pane, hover over a Google BigQuery (Native API) project you want to use and click Add free-from SQL.

      2. Input your SQL and click Add Table from SQL.

    3. Import data by build query:

      1. In the left pane, hover over a Google BigQuery account and click Build a Query.

      2. Choose a project and table.

      3. Select the columns you want to add and click Import.

  9. Click Prepare Data and make any necessary changes.

  10. Click Finish if you are adding a new dataset and go to the next step.

    or

    Click Update Dataset if you are editing an existing dataset and go to the next step.