metabase_field

{“what”:“Unique numeric identifier for this field record.”,“why”:“Primary key for stable references and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:34.891585442+00:00”}

{“what”:“Timestamp when this field record was created.”,“why”:“Audit trail and ordering of field additions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:34.990097462+00:00”}

{“what”:“Timestamp of last modification to this field record.”,“why”:“Tracks changes for sync and cache invalidation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.090900697+00:00”}

{“what”:“Original column name from the database, e.g. ‘user_id’.”,“why”:“Matches physical schema; used for queries and sync.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.217142083+00:00”}

{“what”:“Metabase’s generic data type (e.g. type/Integer, type/Text).”,“why”:“Determines default behavior for filtering, aggregation, and display.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.246448821+00:00”}

{“what”:“Semantic meaning like type/PK, type/FK, type/Category.”,“why”:“Enables smart features like foreign key linking and human-readable labels.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.277963874+00:00”}

{“what”:“Whether this field is currently visible and usable in queries.”,“why”:“Hides deprecated or hidden fields without deleting them.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.307988996+00:00”}

{“what”:“Free-text explanation of the field’s meaning or usage.”,“why”:“Provides context for analysts; shown in UI and docs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.325356282+00:00”}

{“what”:“Whether to show this field in previews and auto-generated charts.”,“why”:“Controls noise in exploratory views; avoids cluttering with irrelevant fields.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.402017869+00:00”}

{“what”:“Display order of the field within its table.”,“why”:“Determines column ordering in UI and exports.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.422830949+00:00”}

{“what”:“Foreign key to the metabase_table that contains this field.”,“why”:“Associates field with its parent table; essential for schema navigation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.475027932+00:00”}

{“what”:“Foreign key to a parent field, for nested or structured fields.”,“why”:“Supports hierarchical fields like JSON or nested objects.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.491896009+00:00”}

{“what”:“Human-friendly label shown in UI, overrides name if set.”,“why”:“Allows renaming without changing physical column name.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.557813936+00:00”}

{“what”:“Visibility mode: normal, sensitive, hidden, etc.”,“why”:“Controls field exposure in queries and dashboards; enforces data privacy.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.660941760+00:00”}

{“what”:“Foreign key to the field that this field references (if FK).”,“why”:“Enables automatic joins and semantic understanding of relationships.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.749639622+00:00”}

{“what”:“Timestamp of last metadata analysis (e.g., fingerprinting).”,“why”:“Indicates freshness of field statistics; triggers re-analysis when stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.972444960+00:00”}

{“what”:“Notes about interesting aspects of the field’s data.”,“why”:“Captures analyst insights for future users.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:35.999545989+00:00”}

{“what”:“Warnings or limitations about the field’s data quality.”,“why”:“Prevents misinterpretation; alerts users to known issues.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.048957848+00:00”}

{“what”:“Serialized summary of field’s data distribution (e.g., min, max, top values).”,“why”:“Powers auto-binning, smart defaults, and data profiling.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.070089107+00:00”}

{“what”:“Version number of the fingerprint format.”,“why”:“Ensures compatibility when fingerprint algorithm changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.104500141+00:00”}

{“what”:“Native database type as reported by the DB, e.g. ‘varchar’.”,“why”:“Preserves original type for accurate query generation and sync.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.118227825+00:00”}

{“what”:“Indicates if field has a list of known values: ‘list’, ‘search’, ‘none’.”,“why”:“Drives filter UI: dropdown vs. search vs. free text.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.150374602+00:00”}

{“what”:“JSON-encoded per-field settings (e.g., formatting, currency).”,“why”:“Stores user preferences without schema changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.198846835+00:00”}

{“what”:“Original column position in the database table.”,“why”:“Preserves physical order for sync and diffing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.214189698+00:00”}

{“what”:“User-defined ordering override for display.”,“why”:“Allows custom ordering independent of database order.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.281548981+00:00”}

{“what”:“Computed type after coercion, e.g. type/DateTime from string.”,“why”:“Determines actual behavior when base_type is overridden.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.298734616+00:00”}

{“what”:“Strategy to convert raw data to effective_type (e.g., ‘ConvertToUTC’).”,“why”:“Defines how to parse and transform values for consistency.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.482268138+00:00”}

{“what”:“Path to nested field in a JSON structure, e.g. ‘$.user.name’.”,“why”:“Identifies subfields for JSON unfolding.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.528248055+00:00”}

{“what”:“Whether the database marks this column as NOT NULL.”,“why”:“Informs validation and query planning; affects required filters.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.548803434+00:00”}

{“what”:“Whether to unfold JSON content into separate fields.”,“why”:“Enables querying nested JSON as individual columns.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.636720026+00:00”}

{“what”:“Whether the database column is auto-incrementing.”,“why”:“Helps identify surrogate keys and default values.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.782062355+00:00”}

{“what”:“Whether the database has an index on this column.”,“why”:“Optimizes query performance; informs index recommendations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.826828345+00:00”}

{“what”:“Whether the column is part of a partition key.”,“why”:“Indicates partitioning strategy for query optimization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.859667682+00:00”}

{“what”:“Flag for fields that are duplicates or defective from sync.”,“why”:“Allows hiding broken fields while preserving data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.877952198+00:00”}

{“what”:“Internal helper for unique field detection.”,“why”:“Supports deduplication and uniqueness checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.920352015+00:00”}

{“what”:“Whether the column is a primary key in the database.”,“why”:“Identifies key fields for joins and row identity.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:36.977387362+00:00”}

{“what”:“Whether the column allows NULL values in the database.”,“why”:“Informs required filters and data quality checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.024925016+00:00”}

{“what”:“Whether the column is generated (computed) by the database.”,“why”:“Prevents writes; indicates read-only nature.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.127547946+00:00”}

{“what”:“Default value expression from the database schema.”,“why”:“Shows expected value when not provided; aids data understanding.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:37.169874358+00:00”}