question

MobashirAhmad-9163 avatar image
0 Votes"
MobashirAhmad-9163 asked KranthiPakala-MSFT commented

Copying from Self-hosted IR Sql Server to Azure data lake Gen 2 Parquet files giving error for tables having SQL_VARIANT cloumn data type

Copying from Self-hosted IR Sql Server to Azure data lake Gen 2 Parquet files giving error for tables having SQL_VARIANT cloumn data type

Error Details: Failure happened on 'Sink' side. ErrorCode=DataTypeNotSupported,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Not supported clr type: Object.,Source=Microsoft.DataTransfer.Richfile.ParquetTransferPlugin,'

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @MobashirAhmad-9163,

Welcome to Microsoft Q&A and thanks for reaching out. By design Sql_Varient could only be processed for sql to sql direct copy pair. Hence this type does NOT support in other sink data stores. Also ADF Copy activity currently supports the following interim data types: Boolean, Byte, Byte array, Datetime, DatetimeOffset, Decimal, Double, GUID, Int16, Int32, Int64, SByte, Single, String, Timespan, UInt16, UInt32, and UInt64.

Please refer to this doc for more info: Data type mapping on ADF copy activity

sql_variant somewhat equals to object which is not a supported type in COPY. Try to see if you can convert the sql-variant to string on the source side query and see if that helps.

Hope this info helps.



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MobashirAhmad-9163,

Just checking in to see if the above suggestion was helpful. If this answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

0 Votes 0 ·

Hi @MobashirAhmad-9163,

We still have not heard back from you. Just wanted to check if the above information was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

0 Votes 0 ·