topic Re: How to store time zone information in Fabric Datawarehouse in Data Warehouse

How to store time zone information in Fabric Datawarehouse

NagaRK — Fri, 27 Jun 2025 14:35:56 GMT

Hi Team,

I have the datetime and timezone infromation in snowflake like below stored in single column in Snowflake. Snowflake has datatype TIMESTAMP_TZ(9) which support both datetime and zone information. But fabric has only datetime data type. How shouId I store the datetime and timezone information together in Fabric Datawarehouse table column. We are inprocess of migraiton. Could you please suggest?

Snowflkake Date time and zone:

2025-04-23 15:36:06.505 +0200

Re: How to store time zone information in Fabric Datawarehouse

lbendlin — Sat, 28 Jun 2025 20:25:51 GMT

Your only option at the moment is a text column. Ideally in ISO-8601 format

Re: How to store time zone information in Fabric Datawarehouse

NagaRK — Tue, 01 Jul 2025 04:24:49 GMT

lbendlin Thanks for your suggestion. I am thinking of following options as well to make use of datetime datatype. What do you suggest?

1) Store the data completely in UTC instead of mainting the zone information

2) Store the datetime in Datetime colum and zone infromation in the varchar column.

Re: How to store time zone information in Fabric Datawarehouse

lbendlin — Tue, 01 Jul 2025 09:34:01 GMT

Option 1 for me, always.

Re: How to store time zone information in Fabric Datawarehouse

BhaveshPatel — Thu, 03 Jul 2025 04:56:08 GMT

For warehouse timezone to work, you should use notebooks.

from pyspark.sql.functions import *

sdf_sk = sdf \

.withColumn("INSERTED_DTM",from_utc_timestamp(current_timestamp(),"Australia/Sydney" )) \

.withColumn("UPDATED_DTM",from_utc_timestamp(current_timestamp(),"Australia/Sydney" )) \

display(sdf_sk)