Azure Data Factory : Data Flow : Display a particular derived columns type

Question

I am trying to determine the outgoing type of a derived column. I am using the expression :

toBinary(sha2(256,'my data')) expecting a BINARY type, its target is a SNOWFLAKE BINARY(64) column.

I am getting a DF-Snowflake-InvalidDataT error from the pipeline run.

Is there a way of actually dumping out the derived type?

Thanks

Stephen

Answer 1

I am trying to determine the outgoing type of a derived column.

You can see the datatype of in the inspect tab of the derived column transformation. Here I have added a column and used same expression.

Here is the inspect tab where you can see the datatype of all columns including the new column.

You can see the same in sink inspect also.