Grail data model
powered by Grail
The Grail data model consists of buckets, tables, and views.
Records are stored in buckets.
Buckets are assigned to tables, including logs, events, metrics, and bizevents tables. Fetching from a table returns all records from all buckets that are assigned to that table.
- Views are reserved for entities, such as
dt.entity. Entities are not stored in buckets and cannot be fetched directly.
Built-in Grail buckets
There is a set of predefined built-in buckets that cannot be modified, including:
- Default buckets, whose name starts with
default_ - System buckets, whose name starts with
dt_
Built-in buckets with corresponding retention periods
| Name | Table | Retention |
|---|---|---|
| events | 35 days |
| bizevents | 35 days |
| logs | 35 days |
| metrics | 15 months |
| spans | 10 days |
| dt.system.events | 1 year |
Custom Grail buckets
You can create a bucket tailored to your needs. Grail buckets behave like folders in a file system and are designed for records that should be handled together. For example, you might need to store together:
Data with the same retention period
Data that needs to be queried/analyzed together
Data that needs to be deleted at the same time
Defining buckets can improve query performance by reducing query execution time and the scope of data read. Finally, having your data stored in a bucket streamlines your permission management because you can easily provide a user group or single users with access to needed data.
A maximum of 80 custom buckets can be created per environment.
For custom buckets, the possible retention periods range from 1 day to 10 years, with an additional week.
Shortening the retention period on update requests will delete the data that is over the new period.
Manage custom Grail buckets
To manage your custom Grail buckets via REST API
-
Open the user menu and make sure Latest Dynatrace is turned on.
-
In the Search field, enter
APIand select Dynatrace API. -
In the Select a definition field, select Bucket Management.
-
Authenticate with your API token.
For details, see Authentication.
-
You can perform the following actions:
To do this Go to Bucket Definitions and select this List my buckets GET/bucket-definitions Create buckets POST/bucket-definitions Update buckets PATCH/bucket-definitions/{bucketName}
or
PUT/bucket-definitions/{bucketName}Truncate buckets POST/bucket-definitions/{bucketName}:truncate Delete buckets DELETE/bucket-definitions/{bucketName}