'Azure Data Factory (V2) Copy Activity - advanced editor missing

Background, Trying to copy data from SQLDB to Blob parquet file. This is being prevented due to a complex column type (geography). I would like to convert this to string data type.

There seems to be a way to do this by checking the "Map complex values to string" box and if that doesn't work use the advanced editor.

Such as seen here:

enter image description here

however, this does not exist in my Azure data factory:

enter image description here

ideas:

  • These features need to be turned on?

but I can't find any documentation on how...

  • They are available in v1 but not yet in v2

I will have to use different method (e.g. dataflow.. powerquery) to copy or different sink dataset type (it works fine with csv but I was hoping to keep the schema.

Your ideas or general thought would be appreciated.

azureazure-data-factory-2


Solution 1:[1]

I would suggest looking into the official MS docs Data type mapping

enter image description here

Also, I don't see the Data Type geography under currently supported ones.

enter image description here

I would suggest you try Data flow for same, using derived column and dynamic expression to set string data type.

enter image description here

Solution 2:[2]

I am assuming that in your case the the source you are pointing to a table in the copy activity . enter image description here You can always select the Query option and write the query , in this case it should help you by as it will help you write a SQL statemnt like

SELECT tostring(yourgepcolumn), other cols from your table

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1
Solution 2 Dharman

Related Questions