How to store time zone information in Fabric Datawarehouse

[NagaRK]

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

[BhaveshPatel]

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)

[NagaRK]

@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.

[lbendlin · Accepted solution]

Option 1 for me, always.

[lbendlin]

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