report_card

{“what”:“Unique integer identifier for the card.”,“why”:“Needed to reference cards from other tables (e.g., dashboard cards, permissions).”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.265215919+00:00”}

{“what”:“Timestamp when the card was created.”,“why”:“Enables audit trails and ordering by creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.292687869+00:00”}

{“what”:“Timestamp of the last modification to the card.”,“why”:“Tracks staleness and supports optimistic concurrency checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.343151787+00:00”}

{“what”:“Human-readable name for the card, e.g., ‘Monthly Revenue’.”,“why”:“Identifies the card in lists and navigation; without it, cards are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.399378276+00:00”}

{“what”:“Free-text description of the card’s purpose or content.”,“why”:“Provides context for other users; without it, intent may be unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.461866244+00:00”}

{“what”:“Display mode for results, e.g., ‘table’, ‘bar’, ‘line’.”,“why”:“Determines how the query results are rendered; missing it would break visualization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.629046925+00:00”}

{“what”:“Serialized query definition (JSON) including database, query type, and filters.”,“why”:“Core of the card; without it, there is no query to execute.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.710034996+00:00”}

{“what”:“Serialized JSON settings for the chosen display, e.g., column formatting.”,“why”:“Controls how the visualization looks; without it, charts lose custom formatting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.875596692+00:00”}

{“what”:“User ID of the card’s creator.”,“why”:“Enables ownership and permission checks; missing it breaks audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:01.939080252+00:00”}

{“what”:“ID of the database the query runs against.”,“why”:“Required to execute the query; without it, the card has no data source.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.025264520+00:00”}

{“what”:“ID of the base table if the query is a simple table query.”,“why”:“Used for metadata and quick query building; may be null for custom queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.050184316+00:00”}

{“what”:“Query type, e.g., ‘query’, ‘native’, ‘mbql’.”,“why”:“Helps parse and validate the query; missing it may break query execution.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.094466996+00:00”}

{“what”:“Flag indicating the card is archived (hidden) but not deleted.”,“why”:“Allows soft deletion without losing data; without it, cards cannot be hidden.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.127658267+00:00”}

{“what”:“ID of the collection (folder) containing the card.”,“why”:“Organizes cards and controls permissions; missing it leaves card ungrouped.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.157762061+00:00”}

{“what”:“UUID for public sharing link.”,“why”:“Enables unauthenticated access via a secret URL; without it, public sharing is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.186574944+00:00”}

{“what”:“User ID who enabled public sharing.”,“why”:“Audit trail for public links; missing it loses accountability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.201263293+00:00”}

{“what”:“Flag indicating the card can be embedded in other apps.”,“why”:“Controls embedding security; without it, embedding would be unrestricted or impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.294630389+00:00”}

{“what”:“Serialized JSON of allowed embedding parameters (e.g., filters).”,“why”:“Defines which parameters can be passed via embedded URL; missing it breaks embedded interactivity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.310186362+00:00”}

{“what”:“Time-to-live in seconds for cached query results.”,“why”:“Controls caching behavior; without it, caching falls back to default.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.342919483+00:00”}

{“what”:“Serialized JSON describing result columns (names, types, formatting).”,“why”:“Used for column-level features like formatting and drill-through; missing it degrades UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.373731104+00:00”}

{“what”:“Numeric position for ordering within the collection.”,“why”:“Controls manual ordering; without it, order is arbitrary.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.402509774+00:00”}

{“what”:“Stable unique identifier (UUID) for the card across environments.”,“why”:“Used for syncing and referencing; missing it breaks external references.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.446615862+00:00”}

{“what”:“Serialized JSON of parameters (e.g., field filters) defined for the card.”,“why”:“Enables interactive filters; without them, dashboards lose parameterization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.486035880+00:00”}

{“what”:“Serialized JSON mapping dashboard parameters to card query parameters.”,“why”:“Connects dashboard filters to card queries; missing it breaks dashboard interactivity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.524210592+00:00”}

{“what”:“Flag indicating whether the card shows a preview in collection.”,“why”:“Controls performance and UI; without it, previews may be heavy.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.550807599+00:00”}

{“what”:“Metabase version that last saved the card.”,“why”:“Tracks schema/feature compatibility; missing it may cause migration issues.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.567276742+00:00”}

{“what”:“Type of card: ‘question’ or ‘model’ (or others).”,“why”:“Distinguishes saved questions from data models; missing it breaks routing and permissions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.705049265+00:00”}

{“what”:“Timestamp when the card was first published (made public).”,“why”:“Audit trail for public sharing; missing it loses history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.869464306+00:00”}

{“what”:“Timestamp when the cache was last invalidated.”,“why”:“Helps manage cache freshness; missing it may serve stale data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.881541260+00:00”}

{“what”:“Timestamp of the last time the card was viewed or executed.”,“why”:“Used for usage analytics and deprecation decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.903859584+00:00”}

{“what”:“Number of times the card has been viewed.”,“why”:“Measures popularity; missing it loses usage metrics.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:02.936879414+00:00”}

{“what”:“Flag indicating the card was archived directly, not via a parent.”,“why”:“Distinguishes direct archive from cascade; helps restore logic.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.003475519+00:00”}

{“what”:“Backup of dataset_query before migration to metrics v2.”,“why”:“Preserves old query for rollback; missing it risks data loss during migration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.046579838+00:00”}

{“what”:“ID of the card this card is based on (e.g., for models).”,“why”:“Tracks lineage; missing it breaks dependency analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.067398204+00:00”}

{“what”:“ID of the dashboard this card belongs to (if it’s a dashboard card).”,“why”:“Links card to dashboard; missing it breaks dashboard membership.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.097315517+00:00”}

{“what”:“Schema version of the card definition.”,“why”:“Enables migrations; missing it breaks versioning.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.210997888+00:00”}

{“what”:“ID of an associated document (e.g., in a knowledge base).”,“why”:“Links card to documentation; missing it loses context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.250685920+00:00”}

{“what”:“Version of dependency analysis performed on the card.”,“why”:“Tracks analysis state; missing it may cause stale dependencies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.287637593+00:00”}

{“what”:“Serialized legacy query format before migration.”,“why”:“Preserves old query for rollback; missing it risks breaking old cards.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.417012079+00:00”}

{“what”:“Type of embedding, e.g., ‘signed’ or ‘token’.”,“why”:“Determines embedding authentication; missing it breaks embedded access.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.457792266+00:00”}

{“what”:“Prefix for public UUID, used for short links.”,“why”:“Enables short URLs; missing it may break existing public links.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:03.479834679+00:00”}