Creating a Stream Query from a Database

  1.  In the Data Manager Sources+ panel, choose the source for which you want to create a stream query. 
    Note The streams associated to that source are displayed. If the Streams panel is empty, no stream queries exist for that source.
  2. Click Stream+ to display the Stream Query window.
    Stream_Query.png

  3. Open the Choose Table/View drop-down menu.
  4. Choose the Table or View for your query.
    Note To preview the Table/View, click the Preview icon.
  5. To edit the query data, click the Pen icon in the Measures & Dimensions panel.
    Measures_and_dimensions.png
  6. To add either a measure or a dimension drag the item from the Available fields column to the relevant column. If the item is not displayed, Search for it.
  7. To add a Date, drag or search for a relevant field from the Available fields column. 
    Note Anodot supports dates and fields with epoch times.
  8. To edit the Schedule Records Collections, click the panel Pen icon. 
    Scheduling_records_collection.png
  9. In Query every, choose a query interval [5 minutes, 15 minutes, hour, day]. 
  10. In Records Time Zone, choose a time zone according to which the records will be processed. The default is UTC.
  11. In Historical Time Span, choose a time span of records to query while initializing the stream.
  12. In Records Delay (Minutes), set the delay. The default is "0".
    Note To minimize partial query results, set the delay according to the delay your internal process takes to prepare the data records.
  13. In Query Backfill Policy, set the backfill missing data records policy after stream initialization. The default is 100. 
    Examples
    0 = Query only last day/hour 
    1 = Query previous and last day/hour
    50 = Query previous 50 last days/hours
  14. Click X to apply the scheduling settings.
  15. Click NEXT. The Stream Table is displayed.

    SEE 
    Using Data Collectors
    Data Manager
    Stream Tables
    Viewing Stream Summaries

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