• Home
  • Platform
  • Grail
  • Data model

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

NameTableRetention

default_events

events

35 days

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 are:

  • 10 days (10 days)
  • 2 weeks (15 days)
  • 1 month (35 days) default
  • 3 months (95 days)
  • 1 year (372 days)
  • 15 months (462 days)
  • 3 years (1,102 days)
  • 5 years (1,832 days)
  • 7 years (2,562 days)
  • 10 years (3,657 days)

Manage custom Grail buckets

To manage your custom Grail buckets via REST API

  1. Open the user menu in the lower-left corner and make sure the Latest Dynatrace toggle is turned on.

  2. In the Search field, enter API and select Dynatrace API.

  3. In the Select a definition field, select Bucket Management.

  4. Authenticate with your API token.

    For details, see Authentication.

  5. You can perform the following actions:

    To do thisGo to Bucket Definitions and select this
    List my bucketsGET/bucket-definitions
    Create bucketsPOST/bucket-definitions
    Update bucketsPATCH/bucket-definitions/{bucketName}
    or
    PUT/bucket-definitions/{bucketName}
    Truncate bucketsPOST/bucket-definitions/{bucketName}:truncate
    Delete bucketsDELETE/bucket-definitions/{bucketName}
Related topics
  • What is Dynatrace Grail data lakehouse?

    Grail is the Dynatrace data lakehouse that's designed explicitly for observability and security data and acts as single unified storage for logs, metrics, traces, events, and more.