SAP Knowledge Base Article - Public

3531169 - Boolean columns Not Visible for Microsoft Azure SQL Database object in Data Flow

Symptom

  • In the creation of a data flow from a Microsoft Azure SQL Database view or remote table, columns containing boolean data are not visible.
  • Only non-boolean columns are displayed in the data flow.
  • This issue occurs when attempting to read data from the Microsoft SQL Database source object.

Environment

  • SAP Datasphere

Reproducing the Issue

  1. Create a data flow;
  2. Attempt to preview data;
  3. Observe that only non-boolean columns are visible in the data flow.

Cause

Non supported datatype.

Resolution

Booltype is not supported by SAP Datasphere's engine. Therefore change column's datatype to BIT.

See Also

Keywords

Azure SQL Database, Data Flow, Boolean Columns, Non-Boolean Columns, Invisible Columns, SAP Datasphere, Data Builder, Flows, Data Flows, SAP Cloud Platform, datatype: "UNKNOWN", nativeDatatype: "booltype", MS SQL, Microsoft SQL , KBA , DS-DI-DF , Data Flows , EIM-DS-DI , DI, DWC, Data Suite usage of DS-Lite , Problem

Product

SAP Datasphere all versions