Creating a Dataset from Google BigQuery Data

You can import data from Google BigQuery into a dataset.

Context

Note
If your SAP Analytics Cloud system is hosted on a data center located within China, this feature is not available.
Note
The login prompt for Google BigQuery is displayed in a popup dialog. You'll need to disable the popup blocker in your browser before trying to connect.

Procedure

  1. Create a new dataset and choose a data source:
    1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  DatasetEnd of the navigation path.
    2. Select Data from a data source.
    3. Select Google BigQuery.
    Note
    From the acquire data panel, select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
  2. Choose an existing BigQuery connection, or create a new one.
  3. Type a name for your query.
  4. Choose whether you want to build a query or type in Freehand SQL.

    If you want to build a query, select a table from the list. If you want to use Freehand SQL, type your query in the Query box. Note: BigQuery standard SQL is supported, but legacy SQL is not.

  5. Select Next.
    If you're building a query, drag objects from the Available Data list to the Selected Data and Filters boxes.
  6. Select Create to begin importing data.

Next Steps

After importing the raw data, continue with data preparation before completing your dataset: About Adding Data to a Story.