metabase_database

{“what”:“Unique integer identifier for the database record.”,“why”:“Needed to reference the database from other tables (queries, permissions).”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.175641629+00:00”}

{“what”:“Timestamp when the database record was created.”,“why”:“Needed for auditing and ordering by creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.190835422+00:00”}

{“what”:“Timestamp of the last update to this record.”,“why”:“Needed to detect stale configurations and for change tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.203077778+00:00”}

{“what”:“Human-readable name for the database, e.g., ‘Production DB’.”,“why”:“Needed to display and identify the database in UI and logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.213655563+00:00”}

{“what”:“Optional free-text description of the database.”,“why”:“Provides context for users; without it, purpose of the database may be unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.226478205+00:00”}

{“what”:“JSON string containing connection details (host, port, credentials).”,“why”:“Required to establish a connection; without it, cannot connect.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.258880252+00:00”}

{“what”:“Database engine type, e.g., ‘postgres’, ‘mysql’.”,“why”:“Determines which driver and SQL dialect to use; without it, connection is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.287309416+00:00”}

{“what”:“Flag indicating if this is Metabase’s sample database.”,“why”:“Distinguishes sample data from user-added databases; used to filter sample data from production.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.300877782+00:00”}

{“what”:“Flag indicating whether to perform full metadata sync.”,“why”:“Controls whether all tables/columns are synced; without it, sync behavior is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.316097271+00:00”}

{“what”:“Free-text notes about interesting aspects of this database.”,“why”:“Provides context for users; without it, insights may be lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.328427079+00:00”}

{“what”:“Free-text warnings or limitations about this database.”,“why”:“Alerts users to known issues; without it, users may make incorrect assumptions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.345310583+00:00”}

{“what”:“Cron expression for when to sync metadata.”,“why”:“Determines how often schema changes are picked up; without it, sync timing is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.371050613+00:00”}

{“what”:“Cron expression for refreshing cached field values.”,“why”:“Controls when field value caches are updated; without it, cache freshness is unpredictable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.385609225+00:00”}

{“what”:“Timezone of the database server.”,“why”:“Needed to interpret timestamps correctly; without it, time-based queries may be off.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.409688014+00:00”}

{“what”:“Flag indicating if field values are fetched on demand.”,“why”:“Controls caching strategy; without it, performance characteristics are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.423624496+00:00”}

{“what”:“Flag indicating if queries can run automatically.”,“why”:“Controls whether users can run queries without manual approval; without it, behavior is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.443727396+00:00”}

{“what”:“Flag indicating if fingerprinting should be redone.”,“why”:“Used to trigger re-analysis of data; without it, stale fingerprints may persist.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.461099873+00:00”}

{“what”:“Time-to-live in seconds for cached query results.”,“why”:“Controls cache expiration; without it, cache behavior is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.480461402+00:00”}

{“what”:“Status of initial metadata sync, e.g., ‘complete’, ‘incomplete’.”,“why”:“Indicates whether the database is ready for querying; without it, readiness is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.496068386+00:00”}

{“what”:“ID of the user who created this database record.”,“why”:“Needed for ownership and audit trails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.515388032+00:00”}

{“what”:“JSON string of additional database-specific settings.”,“why”:“Stores extra configuration not covered by other columns; without it, settings are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.532173206+00:00”}

{“what”:“Version string of the database server.”,“why”:“Needed to determine feature compatibility; without it, version-specific behavior is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.546834851+00:00”}

{“what”:“Flag indicating if this database is used for audit logging.”,“why”:“Distinguishes audit databases from regular ones; used for special handling.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.562640972+00:00”}

{“what”:“Flag indicating if file uploads to this database are allowed.”,“why”:“Controls whether users can upload data; without it, upload capability is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.578609571+00:00”}

{“what”:“Schema name where uploaded tables are stored.”,“why”:“Needed to locate uploaded data; without it, uploads cannot be organized.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.601685554+00:00”}

{“what”:“Prefix for table names created by uploads.”,“why”:“Helps identify uploaded tables; without it, naming is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.615175453+00:00”}

{“what”:“Flag indicating if this is an attached data warehouse.”,“why”:“Distinguishes attached DWH from regular databases; used for routing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.625896312+00:00”}

{“what”:“ID of the database used for routing queries.”,“why”:“Needed to route queries to the correct database; without it, routing is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.644893679+00:00”}

{“what”:“Name of the cloud provider, e.g., ‘aws’.”,“why”:“Used for provider-specific features; without it, provider-specific behavior is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.661096138+00:00”}

{“what”:“Status of workspace permissions for this database.”,“why”:“Indicates if permissions are synced; without it, access control may be inconsistent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.678179616+00:00”}

{“what”:“JSON string with write access details (e.g., credentials for writing).”,“why”:“Needed to enable write operations; without it, writes are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:51.692208746+00:00”}