Creating a Stream Query from a Database

  1.  In the Streams 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.
    SQL_stream_query.png

    Note If there are no Measures in the Stream Query, an editable Events Count column is automatically inserted in the Stream Table.
  3. Choose:
     - Either Table data [Schema and Table].
    Note:
    • To preview the Table data, click the Preview
    • By default Anodot imports your database schema as-is, replacing empty cells with ‘unknown’. To inject a different number of table columns, press the Settings icon. In the Import Settings dialog box, deselect the Replace empty cells check mark box.
     - Or Compose Query, to open the Query Editor.
          Use the sample text and guidelines to build a query.
          Click Preview Results > Run to see the results of the query.
          Click Actual Query > Run to see the actual query [for debugging].
    Query_editor.jpg

  4. To edit the query data, click the Pen icon in the Measures & Dimensions panel.

    MeasuresAndDimensions_epochTime.png

  5. 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.
  6. To add a Date, drag or search for a relevant field from the Available fields column. 
  7. Anodot supports the following datatypes as timestamps:
           DATA
           TIMESTAMP [Epoch Seconds/ Epoch Millis / Epoch Micro]
           INTEGER
           BIGINT
  8. Choose a time zone - Set this to match the Date column timezone.
  9. To edit the Schedule Records Collection, click the panel Pen icon. 

    Schedule_records_collection__Sp71.png

  10. In Query every, set the intraday or daily collection interval. 
  11. In  Time Zone, choose a time zone according to which the records will be processed. The default is UTC.
  12. In Collect Since, choose a time span of records to query while initializing the stream.
  13. 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.
  14. 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
  15. Click X to apply the scheduling settings.
  16. Click NEXT. The Stream Table is displayed.

    SEE 
    Using Data Collectors
    Collecting and Streaming Data
    Stream Tables
    Viewing Stream Summaries

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