sandboxes


Description

{“what”:“A sandbox configuration linking a group to a table and optionally a card.”,“why”:“Without it, per-group table customizations and dependency analysis versions would be lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.915386464+00:00”}

Columns

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

{“what”:“Unique integer identifier for the sandbox row.”,“why”:“Provides a stable reference for foreign keys and updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.927459937+00:00”}

group_id int4 10 null
permissions_group.id fk_gtap_group_id C

{“what”:“Identifier of the group that owns this sandbox.”,“why”:“Scopes sandbox configuration to a specific group; without it, sandboxes would be ambiguous across groups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.945876145+00:00”}

table_id int4 10 null
metabase_table.id fk_gtap_table_id C

{“what”:“Identifier of the table this sandbox applies to.”,“why”:“Determines which table’s attributes are remapped; without it, the sandbox has no target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.966659354+00:00”}

card_id int4 10 √ null
report_card.id fk_gtap_card_id C

{“what”:“Identifier of an optional card within the table; null if sandbox is table-wide.”,“why”:“Distinguishes table-level from card-level sandbox configurations; without it, card-specific overrides are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.979319521+00:00”}

attribute_remappings text 2147483647 √ null

{“what”:“Serialized mapping of attribute names or IDs to new values or aliases.”,“why”:“Preserves custom attribute renames or transformations; without it, customizations are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:37.998019046+00:00”}

dependency_analysis_version int2 5 0

{“what”:“Version number of the dependency analysis used for this sandbox; starts at 0.”,“why”:“Tracks which analysis version produced the remappings; without it, stale analyses cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:38.014176528+00:00”}

Indexes

Constraint Name Type Sort Column(s)
group_table_access_policy_pkey Primary key Asc id
idx_gtap_table_id_group_id Performance Asc/Asc table_id + group_id
idx_sandboxes_card_id Performance Asc card_id
idx_sandboxes_dependency_analysis_version Performance Asc dependency_analysis_version
unique_gtap_table_id_group_id Must be unique Asc/Asc table_id + group_id

Relationships