3455758 - The Data Preview is not working with Datasphere SQL view

The Data Preview of SQL view object is failed with the following error message:

Errors(FORMATTED): cds-compiler model error: Path item 0=xxxrefers to nothing, refCtx: columns Errors(ORIGINAL): cds-compiler model error: Path item 0=xxxrefers to nothing, refCtx: columns

The SQL view contains "SELECT *" statement.

SAP Datasphere

• open the problematic SQL view in Data Builder
• Use Data Preview option

The "SELECT *" statement is not supported in SAP Datasphere - SQL view.

Replace the "SELECT *" statement with "SELECT <column name>".

Supported Date Functions are listed in SAP Help Portal Documentation: Date Functions.

model error,  , KBA , DS-MD-VIW , Views , Known Error