Use StarTree Cloud, which includes an available instance of ThirdEye, ready to connect to data you’ve uploaded into your StarTree Cloud instance of Pinot.
Upload your data into Apache Pinot
Data to be used must have the right data architecture in order to be useful. See ThirdEye data requirements for more information.
Timestamp needs to be in epoch millis for ThirdEye to work efficiently. If there is a non-epoch millis column then convert it to epoch millis using the “derived column” and apply time range indexes based on time granularity used in ThirdEye (Daily, hourly, 15 mins, 1 min).
Based on Query patterns from ThirdEye to Pinot - apply those specific indexing.
Joins are not supported in ThirdEye. Make sure derived columns pre-ingestion are created for those to support TE use cases.
ThirdEye needs a denormalized schema for the following reasons:
TE can run any SQL query Pinot can support for just running alerts. We can do this with a custom template. Link to ThirdEye templates. One can clone this to create a custom template and update the dag in it (query against Pinot). However, all the templates need to be cloned to add this custom query)
The complexity is more on: how the metric is then defined, how people can choose different detection algorithms on it, how it is exposed in the UI, how that is shared in RCA, notifications, etc., alerts might work, but the entire experience is not great. RCA may break. If RCA top contributors, heatmap needs to provide accurate insights at a quicker speed then transformed data will be ideal.
If there are too many dimensions in the table how to make RCA more performant? Ans: Number of dimensions in a schema - indexes on dimensions (too many dimensions will slow down RCA UI) - rcaExcludedDimensions Link to the doc
To make your data accessible by ThirdEye, you must connect ThirdEye to a datasource.If you’re using StarTree Cloud, see an example of how to load a sample dataset section.If you are using StarTree Cloud, when you open ThirdEye, ThirdEye automatically connects to Pinot and guides you through the connection process.
Create one or more groups for alerts to be sent to, each with one or more routes for sending the notifications, such as email, Slack, or PagerDuty. These groups are called Subscription Groups in ThirdEye.Notifications are sent to subscription groups. The entire set of subscription groups and routes is referred to as a notification system.Create your notification system first so that you have a place to send alert notifications when you create the alerts.