The logical type TimeSpan is not supported in Delta format. Reason: Cannot find supported delta type

[DarylF]

Iv created a pipline from snowflake that has muliple date/time columns, but getting the below error even if setting the data type mapping to a string?

ErrorCode=DeltaNotSupportedLogicalType,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The logical type TimeSpan is not supported in Delta format. Reason: Cannot find supported delta type for column name INTERACTION_START_TIME, logical type TimeSpan,Source=Microsoft.DataTransfer.ClientLibrary,'

Any suggestions greatly appreciated

[DarylF]

Hi thanks tried the above steps with little luck. Abonded it and went to mirror and LOL now have a new error message that im trying to find the detail on, can find no error in Snowflake when the querys run.  Current is a warning message "Running with warnings". But no where i can find what the warnings are it just stopped replicating. other 3 tables i have are running fine just 2 large tables stopped. 
Anyone know where i can check logs or additional details on the warnining message?

[v-cboorla-msft]

Hi @DarylF 

Thanks for using Microsoft Fabric Community.

As I understand that you are trying to copy the data from snowflake to Microsoft Fabric using Pipeline but encountering an error "The logical type TimeSpan is not supported in Delta format. Reason: Cannot find supported delta type."

Troubleshooting step : Consider changing the data type of the INTERACTION_START_TIME column in Snowflake to a supported type (e.g., datetime or timestamp) before copying it to Microsoft Fabric.

For details please refer : Data types in Microsoft Fabric.

I hope this information helps. Please do let us know if you have any further questions.

Thanks.

[DarylF]

Thanks this was my next logical step that my team is testing on. Will let you know if it works

[v-cboorla-msft]

Hi @DarylF 

Did you got a chance to check with your team whether they have tested it? or just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @DarylF 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.

[v-cboorla-msft]

Hi @DarylF 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks