Datasphere: Changing the data type in a dataflow for non-sap source to the target table.

[felix_graham]

Hello everyone,

In data builder, when creating a dataflow from non-SAP source, the source table in the dataflow automatically assigns string (5000) to all varchars data fields. Is it possible to change the data type before creating and deploying to a local table in the data builder?

Thanks!

FG

[XaviPolo]

I think what you are talking about is not because of the dataflow.

When importing a remote table, the metadata from the source is used. If you add for example a SQL table that defines a varchar(30) you will see it like this in DSP, but there are certain data sources that do not give so much information in the metadata (like json) and for example return "String" without specifying size, so DSP defaults to 5000.

You can in a view or within the DF itself, create a new calculated field that for example does a left(field, 10) to keep the first 10 characters or whatever.

Regards,

[vishalakshmi]

Hello Felix,

Please refer to the below documentation:

https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/f315863264db489593c7f54f1f...

String (Variable-length Unicode string of up 5000 characters.) can be converted to Binary, Boolean, Date, Datetime, Decimal, Double, hana.SMALLINT, hana.TINYINT, hana.SMALLDECIMAL, hana.REAL, hana.BINARY, Integer, Integer64, LargeBinary, LargeString, Time, Timestamp.

https://help.sap.com/docs/SAP_DATASPHERE/c8a54ee704e94e15926551293243fd1d/7b1dc6e0fad147de8e50aa8dc4...

Thanks,

Lakshmi.