persisted_info


Columns

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

{“what”:“Unique integer identifier for each persisted info record.”,“why”:“Without it, records cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:04.890717873+00:00”}

database_id int4 10 null
metabase_database.id fk_persisted_info_database_id C

{“what”:“Identifier of the database the query runs against.”,“why”:“Without it, we don’t know which database the persisted data belongs to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:04.929056868+00:00”}

card_id int4 10 √ null
report_card.id fk_persisted_info_card_id N

{“what”:“Identifier of the card that triggered this persistence, if any.”,“why”:“Without it, we cannot link the persisted info to a specific card.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:04.950577105+00:00”}

question_slug text 2147483647 null

{“what”:“Human-readable slug for the question, e.g., ‘sales-by-month’.”,“why”:“Without it, we cannot identify the question in URLs or logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:04.980994003+00:00”}

table_name text 2147483647 null

{“what”:“Name of the destination table where the data is persisted.”,“why”:“Without it, we don’t know where the data is stored.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.035226733+00:00”}

definition text 2147483647 √ null

{“what”:“Query definition or SQL text used to generate the data.”,“why”:“Without it, we cannot reproduce or audit the query.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.052779191+00:00”}

query_hash text 2147483647 √ null

{“what”:“Hash of the query definition for quick comparison.”,“why”:“Without it, we cannot detect if the query changed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.069500313+00:00”}

active bool 1 false

{“what”:“Whether this persistence is currently active (true/false).”,“why”:“Without it, we cannot filter out inactive entries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.086508045+00:00”}

state text 2147483647 null

{“what”:“Current state of the persistence job, e.g., ‘running’, ‘success’, ‘failed’.”,“why”:“Without it, we cannot know if the data is ready or if a refresh is needed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.120204839+00:00”}

refresh_begin timestamptz 35,6 null

{“what”:“Timestamp when the last refresh started.”,“why”:“Without it, we cannot measure refresh duration or schedule.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.131301705+00:00”}

refresh_end timestamptz 35,6 √ null

{“what”:“Timestamp when the last refresh finished.”,“why”:“Without it, we cannot know if refresh is still running or compute duration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.145383665+00:00”}

state_change_at timestamptz 35,6 √ null

{“what”:“Timestamp of the last state change.”,“why”:“Without it, we cannot know how long the current state has been in effect.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.157280207+00:00”}

error text 2147483647 √ null

{“what”:“Error message from the last failed refresh.”,“why”:“Without it, we cannot diagnose failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.170457486+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when this record was created.”,“why”:“Without it, we cannot track when the persistence was set up.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.185863914+00:00”}

creator_id int4 10 √ null
core_user.id fk_persisted_info_ref_creator_id R

{“what”:“Identifier of the user who created this persistence.”,“why”:“Without it, we cannot attribute ownership.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.196738533+00:00”}

Indexes

Constraint Name Type Sort Column(s)
persisted_info_pkey Primary key Asc id
idx_persisted_info_creator_id Performance Asc creator_id
idx_persisted_info_database_id Performance Asc database_id
persisted_info_card_id_key Must be unique Asc card_id

Relationships