Schemas & Mapping

Configure data type, nullable, transform, and timezone (for datetimes only) per column. Use duration for elapsed times such as 00:00:02 (stored as seconds). For datetimes, pick a region zone (e.g. America/Denver) so daylight saving is applied; the IANA abbreviations MST/PST/CST/EST are fixed standard offsets without DST — the app maps those to the matching America/… zone. Arizona (no DST): use America/Phoenix. Adj (h) (datetime only) adds whole hours to the parsed instant before timezone conversion (e.g. vendor skew). The worker uses this when loading data. Reconcile (add/remove columns after report drift) is coming later.