Google BigQuery

This article contains sections on:

Creating a BigQuery data source 
Creating a BigQuery stream query

CREATING A BIGQUERY DATA SOURCE

  1. In the Data Manager window, click Sources +.
  2. In the Source Types window, click START on the Google BigQuery G_BigQuery.ico tile.
  3. Sign in with your Google account.
  4. Allow anodot.com to access your Google account. The Stream Query window is displayed.

CREATING A BIGQUERY STREAM QUERY

If you have just created a BigQuery data source, skip to step 3.

  1. In the Data Manager Sources + panel, choose the BigQuery source for which you want to create a stream query. 
    Note: The streams associated with that source are displayed. If the Streams panel is empty, no stream queries exist for that source.
  2. Click Streams + to display the Stream Query dialog box. 
    BQ_StreamQuery_draft2.png
  3. Choose a Project.
  4. Choose a Data Set (optional).
  5. Click the Query Schedule Edit icon to open the Query Schedule page.
    BQ_ScheduleQuery_final.png
  6. Choose:
    i.  The time period to Collect data.
    ii. Set the Delay delta.
    iii. A Time Zone according to which the data will be processed.
    vi. An Historical time span of data to collect while initializing a stream.
  7. Click × to accept your query schedule and return to the Stream Query page.
  8. Click Compose Query to open the Query Editor.
    BQ_Query_Editor_final.png

  9. Use the sample text and guidelines to build a query.
  10. To use Standard SQL, deselect the Use Legacy SQL
  11. Click Preview Query.
  12. Once you are satisfied with the query, click CONTINUE to return to the Stream Query page - the Dates, Measures and Dimensions  are displayed.
    BQ_MeasuresDimensions_fake_01.png
  13. To edit any of the Measures & Dimensions, click Edit icon, to open the Measures & Dimensions page.
    BQ_measuresDimension_DB_fake02.png
  14. Edit the parameters you want to change:
    i.   Date
    ii.  Measures
    iii. Dimensions
  15. Click × to accept the chosen parameters and return to the Stream Query page.
  16. Click NEXT to display the Stream Table

Relevant Articles
Using Data Collectors
Data Manager
Stream Tables
Viewing Stream Summaries

Was this article helpful?
0 out of 0 found this helpful
-->