Forum Discussion

Noeleke1301's avatar
Noeleke1301
Icon for Helper III rankHelper III
2 years ago
Solved

DateTime timezone changes while copying to .parquet

I've set up a data pipeline that copies data from our oracle database to a Fabric lakehouse. However, when using .parquet I can see times being changed (likely due to daylight savings), f.e. 2024-03-...
  • Noeleke1301's avatar
    Noeleke1301
    2 years ago

    Hi,

    I think I figured out the problem. My source system doesn't have any timezone specification in their datetime fields. I've read that parquet self-assigns a timezone to the value if the source doesn't give any.

    Since the Fabric capacity is probably in another timezone, it changes the default timezone of my .parquet files.

     

    I've had to set the correct timezone in my spark notebook to correct this. More info on:

    Spark: queries with datetime and time zones - KeesTalksTech