metabase_table

{“what”:“Unique integer identifier for this table record.”,“why”:“Needed as primary key for referencing from other tables and for updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.779679181+00:00”}

{“what”:“Timestamp with time zone when this record was created.”,“why”:“Needed for auditing and ordering by creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.791490859+00:00”}

{“what”:“Timestamp with time zone of the last update to this record.”,“why”:“Needed for change tracking and optimistic locking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.806912026+00:00”}

{“what”:“Name of the table as it appears in the source database.”,“why”:“Needed to identify the table in queries and UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.820744703+00:00”}

{“what”:“Free-form text describing the table’s purpose.”,“why”:“Provides context for users; without it, table purpose is unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.833771888+00:00”}

{“what”:“Classification of the table, e.g., ‘table’, ‘view’, ‘question’.”,“why”:“Needed to distinguish table types for UI and permission logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.852225176+00:00”}

{“what”:“Boolean indicating whether the table is currently active and usable.”,“why”:“Inactive tables are hidden or excluded; without it, stale tables appear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.867694045+00:00”}

{“what”:“Foreign key to the database (Metabase database) this table belongs to.”,“why”:“Needed to associate table with its source database.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.882929520+00:00”}

{“what”:“Human-friendly name shown in UI, may differ from ‘name’.”,“why”:“Needed for user-facing labels; without it, raw name may be cryptic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.902646333+00:00”}

{“what”:“Controls visibility of table, e.g., ‘normal’, ‘hidden’, ‘technical’.”,“why”:“Needed to filter tables from user views.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.917630727+00:00”}

{“what”:“Database schema (namespace) containing the table.”,“why”:“Needed to fully qualify table name and avoid ambiguity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.931250420+00:00”}

{“what”:“Notes about interesting aspects of the table.”,“why”:“Provides guidance to users; without it, insights are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.942780418+00:00”}

{“what”:“Warnings or limitations about the table’s data.”,“why”:“Alerts users to potential issues; without it, data may be misinterpreted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.961009834+00:00”}

{“what”:“Boolean indicating whether to display this table in the ‘Getting Started’ guide.”,“why”:“Controls onboarding content; without it, new users miss sample tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:24.989405298+00:00”}

{“what”:“Ordering scheme for fields, e.g., ‘database’, ‘alphabetical’.”,“why”:“Determines field display order; without it, order is unpredictable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.006623425+00:00”}

{“what”:“Status of initial metadata sync, e.g., ‘incomplete’, ‘complete’.”,“why”:“Needed to know if table metadata is fully loaded.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.023173651+00:00”}

{“what”:“Boolean indicating whether this table was created via CSV upload.”,“why”:“Distinguishes user-uploaded tables from database tables.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.036073827+00:00”}

{“what”:“Boolean indicating whether queries on this table require a filter.”,“why”:“Needed to enforce query safety; without it, expensive queries may run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.047442232+00:00”}

{“what”:“Approximate number of rows in the table.”,“why”:“Used for query planning and UI display; without it, size unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.066815638+00:00”}

{“what”:“Number of times this table has been viewed.”,“why”:“Tracks popularity; used for sorting or recommendations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.083497412+00:00”}

{“what”:“Boolean indicating whether this table is a defective duplicate of another.”,“why”:“Needed to hide or flag duplicates; without it, confusion arises.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.101641588+00:00”}

{“what”:“Helper string to ensure uniqueness of table names across databases.”,“why”:“Needed to avoid name collisions; without it, ambiguous references.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.119140751+00:00”}

{“what”:“Timestamp when table was deactivated.”,“why”:“Needed to know when table became inactive.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.130633851+00:00”}

{“what”:“Timestamp when table was archived.”,“why”:“Needed to know when table was archived for cleanup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.143731002+00:00”}

{“what”:“Boolean indicating whether the table allows write operations.”,“why”:“Needed to control data modification permissions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.156572376+00:00”}

{“what”:“Authority level for data, e.g., ‘unconfigured’, ‘official’.”,“why”:“Needed to indicate data trustworthiness.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.190145505+00:00”}

{“what”:“Source of the data, e.g., ‘system’, ‘user’.”,“why”:“Needed to understand data origin.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.202618962+00:00”}

{“what”:“Layer in data architecture, e.g., ‘raw’, ‘staging’.”,“why”:“Needed to classify data processing stage.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.223120897+00:00”}

{“what”:“Email of the user who owns this table.”,“why”:“Needed for ownership and contact.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.238301210+00:00”}

{“what”:“Foreign key to the user who owns this table.”,“why”:“Needed to link to user account.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.261869708+00:00”}

{“what”:“Foreign key to the collection this table belongs to.”,“why”:“Needed for organization and permissions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.271093433+00:00”}

{“what”:“Boolean indicating whether this table is published to a wider audience.”,“why”:“Controls visibility; without it, unpublished tables may be exposed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.287240966+00:00”}

{“what”:“Foreign key to a transformation definition applied to this table.”,“why”:“Needed to track data transformations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:25.307241141+00:00”}