Grail data model
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 buckets, ensure that you have configured the following permissions:
storage:bucket-definitions:readstorage:bucket-definitions:writestorage:bucket-definitions:deletestorage:bucket-definitions:truncate
With Storage Management you can:
Create custom buckets for Events, BizEvents, Logs and Spans.
Edit custom buckets.
Delete custom buckets.
Creating new buckets with Storage Management
To create a new custom Grail bucket with Storage Management you need to specify:
Unique bucket name. It has to be between 3-100 characters long and has to start with a letter. The bucket name can only contain lowercase alphanumeric characters, underscores and hyphens. The bucket name can't be edited or changed at a later time.
Display name. You can use this field to describe your bucket.
Retention period between 1-3657 days.
Manage custom Grail buckets via REST API
Latest Dynatrace
To manage your custom Grail buckets via REST API
-
Search for and select Dynatrace API.
-
In the Select a definition field, select Grail Storage Management.
-
Authenticate with your API token.
For details, see Authentication.
-
Perform one of 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}