Time Zone Support

Dremio does not apply any conversions to the TIME or TIMESTAMP entry that is in the datasource table. Dremio retrieves the time or timestamp value with the assumption that the time zone is in Coordinated Universal Time (UTC).

For Parquet datasets where the time zone is specified in the Parquet file (for example, Pacific Standard Time or PST), Dremio automatically converts the value of the timestamp to UTC.

Time Zone Limitation

For JSON files where the time zone for the time or timestamp values are not in UTC time, Dremio assumes and processes the values as in UTC time. For such files, we recommend that you convert these values to the UTC time zone before using in Dremio.