Importing Google BigQuery Data to a New or Existing Model

If your data files are stored on Google BigQuery, you can connect directly to Google and select a file from there.

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. Select the appropriate option:

    • If you're creating a new model:

      1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  ModelEnd of the navigation path.
      2. Select Get 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.

    • If you're importing into an existing model:

      1. Select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  FilesEnd of the navigation path.
      2. Open the model you want to update.
      3. Switch to the Data Management screen.

      4. Select Start of the navigation path Next navigation step Data sourceEnd of the navigation path.
      5. Select Google BigQuery.
      Note
      You can 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. Create a new query, or copy an existing query, and then select OK.
  4. Type a name for your query.
  5. 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.

  6. Select Next.
    If you're building a query, drag objects from the Available Data list to the Selected Data and Filters boxes.
  7. Create a new query, or copy an existing query, and then select OK.
  8. Select Create to begin importing data.

Next Steps

After the initial import of raw data, continue with the data preparation task before completing your model: Preparing Data.