segment


Description

{“what”:“A named, reusable subset of rows from a source table, defined by a query.”,“why”:“Without it, there is no way to group rows for analysis or sharing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.753471391+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique integer identifier for the segment.”,“why”:“Without it, rows cannot be referenced or joined uniquely.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.795324788+00:00”}

table_id int4 10 null
metabase_table.id fk_segment_ref_table_id C

{“what”:“Identifier of the source table this segment is defined on.”,“why”:“Without it, the segment’s scope is unknown and cannot be applied to the correct data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.806708308+00:00”}

creator_id int4 10 null
core_user.id fk_segment_ref_creator_id C

{“what”:“Identifier of the user who created the segment.”,“why”:“Without it, ownership and audit trail are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.825363495+00:00”}

name varchar 254 null

{“what”:“Short human-readable name for the segment, e.g., ‘Active Users’.”,“why”:“Without it, segments cannot be distinguished in lists or UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.850989457+00:00”}

description text 2147483647 √ null

{“what”:“Free-form explanation of the segment’s purpose or contents.”,“why”:“Without it, future users cannot understand the segment’s intent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.861719918+00:00”}

archived bool 1 false

{“what”:“Flag indicating whether the segment is hidden from active use (true) or available (false).”,“why”:“Without it, retired segments would clutter the interface and confuse users.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.887863129+00:00”}

definition text 2147483647 null

{“what”:“Query or condition logic that selects the segment’s rows from the source table.”,“why”:“Without it, the segment has no actual data and cannot be executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.922937887+00:00”}

created_at timestamptz 35,6 null

{“what”:“Timestamp when the segment was created, in UTC.”,“why”:“Without it, creation order and audit history are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.955883291+00:00”}

updated_at timestamptz 35,6 null

{“what”:“Timestamp of the last modification to the segment, in UTC.”,“why”:“Without it, stale or conflicting edits cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:36.974886088+00:00”}

points_of_interest text 2147483647 √ null

{“what”:“Notes about notable rows or patterns within the segment.”,“why”:“Without it, analysts lose context on interesting data points.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.003203748+00:00”}

caveats text 2147483647 √ null

{“what”:“Warnings or limitations about the segment’s data or definition.”,“why”:“Without it, users may misinterpret results or apply the segment incorrectly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.025321209+00:00”}

show_in_getting_started bool 1 false

{“what”:“Flag indicating whether the segment appears in the getting-started guide (true) or not (false).”,“why”:“Without it, onboarding content cannot be curated for new users.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.070635095+00:00”}

entity_id bpchar 21 √ null

{“what”:“Single-character code for the entity type the segment is associated with.”,“why”:“Without it, the segment’s target entity type is ambiguous when multiple entity types exist.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.113278123+00:00”}

dependency_analysis_version int4 10 0

{“what”:“Integer version number for the dependency analysis algorithm used on this segment.”,“why”:“Without it, changes in analysis logic cannot be tracked or invalidated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:37.143018171+00:00”}

Indexes

Constraint Name Type Sort Column(s)
segment_pkey Primary key Asc id
idx_segment_creator_id Performance Asc creator_id
idx_segment_show_in_getting_started Performance Asc show_in_getting_started
idx_segment_table_id Performance Asc table_id
segment_entity_id_key Must be unique Asc entity_id

Relationships