Strategy One

Connect to Google BigQuery (Native API)

Create an OAuth App in Google

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

  2. In the left navigation, click Credentials under APIs & Services.

  3. Click Create credentials and choose OAuth client ID.

  4. Expand the Application type drop-down list and choose Web application.

  5. Type an application Name and click Create.

  6. Copy the Client ID and Client secret values or click Download JSON. You will need Client ID and Client secret for future steps.

  7. Click OK.

  8. Click the application you just created.

  9. Click Add URI and add a 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

  10. Click Save.

Create a Google BigQuery Data Source

Prerequisites

You must have the Configure security settings and Create and edit database instances and connections privileges.

Create a New Authentication Service in Workstation

For more information on creating identity and access management (IAM) objects, see Manage OAuth Enterprise Security with Identity and Access Management (IAM) Objects.

  1. Open the Workstation window.

  2. In the Navigation pane, click , next to Enterprise Security.

  3. Choose Gateway Authorization and click Next.

  4. Type a Display Name.

  5. Expand the Select an identity provider drop-down list, choose Google.

  6. In Strategy Configuration, enter the Client ID and Client Secret you copied in Create an OAuth Application in Google.

  7. Click Save.

Connect to Google Google BigQuery (Native API) in Mosaic Studio

  1. Create a Mosaic model or right-click an existing Mosaic model and choose Edit.
  2. In the Sources tab, click Add API Source.

  3. Click Google BigQuery (Native API).

  4. Type a Name for the data source.

  5. Expand the Authentication Service drop-down list and choose the authentication service you created in Create a New Authentication Service in Workstation.

  6. Optionally click Test.

  7. If the connection is successful, click Save.

Import Data

  1. Click your Google BigQuery source and enter your Google Login.

  2. Choose one of the following options to import Google BigQuery data:

    1. Import data with tables:

      1. In the left pane, choose the Google BigQuery (Native API) projects.

      2. Expand the datasets to browse tables.

      3. Hover over a table and click Add.

    2. Import data by Freeform SQL:

      1. Click Free-form SQL.

      2. Enter the SQL and click Add Table.

  3. Click Proceed.

  4. View and choose suggestions, view object logical relationships, or automatically create attributes and metrics.

  5. Click Save, Save as, or Publish.

  6. If you Saveor Save as your Mosaic model:

    1. Type a Name and Description.

    2. Choose a Save in folder location.

    3. Optionally, select the check box next to Certify Mosaic Model.