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, metrics, events, security events, and bizevents tables. Fetching from a table returns all records from all buckets that are assigned to that table.
  • Entities, such as dt.entity, 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

default_events

events

35 days

default_security_events

events

3 years

default_security_custom_events

events

1 year

default_bizevents

bizevents

35 days

default_logs

logs

35 days

default_metrics

metrics

15 months

default_spans

spans

10 days

dt_system_events

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:read
  • storage:bucket-definitions:write
  • storage:bucket-definitions:delete
  • storage: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

  1. Search for and select Dynatrace API.

  2. In the Select a definition field, select Grail Storage Management.

  3. Authenticate with your API token.

    For details, see Authentication.

  4. 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}

Related topics