Error: Parquet File Timestamp Column Has Wrong UTC Adjustment
Issue
While loading data from an S3 Iceberg table to Snowflake, the following error appears:
Parquet file timestamp column has wrong UTC adjustment. TIMESTAMP_NTZ columns expect values without UTC adjustment and TIMESTAMP_LTZ columns expect values with UTC adjustment. Actual adjustment: 'false',
Environment
Destination: S3 Data Lake
Resolution
To resolve this issue, do the following:
- Drop the Parquet files associated with the affected table from your S3 bucket.
- Perform a historical re-sync for the affected table. To learn more, see How to Trigger a Historical Table Re-Sync.
Cause
This issue occurs when the timestamptz
columns in the affected tables store data without adjusting timestamps to UTC.