OpenTelemetry schema in Delta Lake representation

otel-delta.dbml

Table "columnar"."log" {
    "id" varchar [pk]
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "time_utc" datetime2
    "observed_time_utc" datetime2
    "scope_name" varchar
    "scope_version" varchar
    "trace_id" varchar
    "span_id" varchar
    "severity_number" bigint
    "severity_text" varchar
    "body_str" varchar
}

Table "columnar"."log_attributes" {
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "observed_time_utc" datetime2
    "key" varchar
    "str" varchar
    "bool" bit
    "int" varchar
    "double" float
    "array_val_json" varchar
    "map_val_json" varchar
}

Table "columnar"."log_resource_attributes" {
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "observed_time_utc" datetime2
    "key" varchar
    "str" varchar
}

Table "columnar"."log_scope_attributes" {
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "observed_time_utc" datetime2
    "key" varchar
    "str" varchar
}

Table "columnar"."metric" {
    "id" varchar [pk]
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "event_hub_enqueued_time_utc" datetime2
    "scope_name" varchar
    "scope_version" varchar
    "metric_name" varchar
    "metric_unit" varchar
    "metric_description" varchar
}

Table "columnar"."metric_data_point_attributes" {
    "parent_id" varchar [pk]
    "metric_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "event_hub_enqueued_time_utc" datetime2
    "key" varchar
    "str" varchar
}

Table "columnar"."metric_gauge_data_points" {
    "id" varchar [pk]
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "event_hub_enqueued_time_utc" datetime2
    "time_utc" datetime2
    "metric_type" varchar
    "value" varchar
}

Table "columnar"."metric_resource_attributes" {
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "event_hub_enqueued_time_utc" datetime2
    "key" varchar
    "str" varchar
}

Table "columnar"."metric_scope_attributes" {
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "event_hub_enqueued_time_utc" datetime2
    "key" varchar
    "str" varchar
}

Table "columnar"."metric_sum_data_points" {
    "id" varchar [pk]
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "event_hub_enqueued_time_utc" datetime2
    "start_time_utc" datetime2
    "time_utc" datetime2
    "metric_type" varchar
    "aggregation_temporality" varchar
    "is_monotonic" bit
    "value" varchar
}

Table "columnar"."span" {
    "id" varchar [pk]
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "start_time_utc" datetime2
    "end_time_utc" datetime2
    "duration_time_nano" bigint
    "scope_name" varchar
    "scope_version" varchar
    "trace_id" varchar
    "span_id" varchar
    "parent_span_id" varchar
    "name" varchar
    "kind" bigint
}

Table "columnar"."span_attributes" {
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "start_time_utc" datetime2
    "end_time_utc" datetime2
    "key" varchar
    "str" varchar
}

Table "columnar"."trace_resource_attributes" {
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "start_time_utc" datetime2
    "end_time_utc" datetime2
    "key" varchar
    "str" varchar
}

Table "columnar"."trace_scope_attributes" {
    "parent_id" varchar
    "event_year_date" varchar
    "region" varchar
    "service_name" varchar
    "start_time_utc" datetime2
    "end_time_utc" datetime2
    "key" varchar
    "str" varchar
}

// Foreign key relationship 1.
Ref {
    "columnar"."log_attributes"."parent_id" > "columnar"."log"."id"
}

// Foreign key relationship 2.
Ref {
    "columnar"."log_resource_attributes"."parent_id" > "columnar"."log"."id"
}

// Foreign key relationship 3.
Ref {
    "columnar"."log_scope_attributes"."parent_id" > "columnar"."log"."id"
}

// Foreign key relationship 5.
Ref {
    "columnar"."span_attributes"."parent_id" > "columnar"."span"."id"
}

// Foreign key relationship 6.
Ref {
    "columnar"."trace_resource_attributes"."parent_id" > "columnar"."span"."id"
}

// Foreign key relationship 7.
Ref {
    "columnar"."trace_scope_attributes"."parent_id" > "columnar"."span"."id"
}

// Foreign key relationship 9.
Ref {
    "columnar"."metric_resource_attributes"."parent_id" > "columnar"."metric"."id"
}

// Foreign key relationship 10.
Ref {
    "columnar"."metric_scope_attributes"."parent_id" > "columnar"."metric"."id"
}

// Foreign key relationship 11.
Ref {
    "columnar"."metric_sum_data_points"."id" > "columnar"."metric_data_point_attributes"."parent_id"
}

// Foreign key relationship 12.
Ref {
    "columnar"."metric_gauge_data_points"."id" > "columnar"."metric_data_point_attributes"."parent_id"
}

// Foreign key relationship 14.
Ref {
    "columnar"."metric_data_point_attributes"."metric_id" > "columnar"."metric"."id"
}