Import Data Connection to a Google BigQuery System

How to create a connection that allows you to import models from a Google BigQuery system.

Prerequisites

You need to have a Google account that has access to a BigQuery project.

Procedure

  1. Go to Start of the navigation path (Main Menu) Next navigation step  Connection Next navigation step Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a datasource dialog will appear.
  2. Expand Acquire Data and select Google BigQuery.
    You may be requested to allow offline access to your account when your device is turned off. You'll need to allow access for SAP Analytics Cloud to be able to access your BigQuery projects.
  3. In the New Google BigQuery Connection dialog, enter a name and a description for the connection.
  4. Sign in to your Google BigQuery account.
    Note
    If you're unable to create a connection when using Microsoft Edge, please check your Trusted Sites (Control Panel > Internet Options > Security > Trusted Sites > Sites), and do one of the following:

    Remove https://*.sapbusinessobjects.cloud/ from your Trusted Sites.

    Or

    Add about:blank and https://accounts.google.com/ to your Trusted Sites.

  5. Choose a BigQuery project from the list, and then select OK.
    The new connection is added to the list of connections on the Connections screen.
  6. If you want to create a model based on this connection, see Importing Google BigQuery Data to a New or Existing Model.