I got the error message below when sinking data from SQL Server to Databricks.

“ErrorCode=AzureDatabricksComplexTypesNotSupported,We don’t support complex types (struct, map, array) in copy activity.”

Apparently I don’t have these data types in the source table, except varchar(max) which I guess it caused the issue.

I believe I’m not the only one running into this issue,any suggestions?

Thanks!

​I got the error message below when sinking data from SQL Server to Databricks.”ErrorCode=AzureDatabricksComplexTypesNotSupported,We don’t support complex types (struct, map, array) in copy activity.”Apparently I don’t have these data types in the source table, except varchar(max) which I guess it caused the issue.I believe I’m not the only one running into this issue,any suggestions?Thanks!    Read More

​