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.

Note
External data sources, including Google Drive, Google Cloud BigTable, and Google Cloud Storage, are not supported as a BigQuery data source. For Google Drive data, you can choose the Google Drive data source instead.
Note

If your SAP Analytics Cloud system is hosted on a data center located within China, this feature is not available.

Procedure

  1. From the side navigation, choose Start of the navigation path Connections Next navigation step  (Add Connection)End of the navigation path.
    The Select a data source 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. To add about:blank, you'll need to clear the “Require server verification (https:) for all sites in this zone” option temporarily, but you can re-enable it afterward.

    You may need to restart your computer after making this change.

  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 Import Data to Your Model.
    Note

    (Beta) Select the Enable users to schedule for story publishing option if you want to let your users schedule the publishing of stories. For details on scheduling, see Schedule a Publication.