Skip to main content

Data Time Zone

Sets the time zone for loading timestamps in notebooks. This setting does not alter the original data but converts timestamps to the chosen time zone.

When set, the generated load SQL appends the zone when converting date and timestamp columns (for example TO_TIMESTAMP(CONCAT(DATE_FORMAT(column, 'yyyy-MM-dd HH:mm:ss.SSSSSSS'), ' <zone>'))) so source values are interpreted in the configured zone consistently across the loads, including in the hash calculations used for change detection. When blank (the default), values are interpreted in the session time zone.

When to Change This Setting​

Set it when source timestamps are recorded in a known zone that differs from the Databricks session zone, so loaded values and row hashes stay consistent regardless of where the notebooks run.

SettingInteraction
Display Time ZoneSets the session time zone for rendering, without affecting conversion during load

Notes​

  • This setting is part of the Databricks settings category.
  • This setting is blank by default.