Datasphere - SQL View - Set Business Name in SQL Select

[axel_]

Hi Folks,

I use a SQL View to rename some columns

Select
"AUTOID" AS "VK_AUTOOD"
from tablexy

Issue is that this changes only technical name. Business name will remain. Which will lead to quite some confusion in Analytical Model an front-end.

Is there an addition that will also set the business name?

Thanks and best regards

Axle

[Chris_Tam]

Hi axel_,

In the Model Properties panel of the SQL view in datasphere, there should be a section where Columns are listed with a pencil icon:

From there you can change the Business Name to whatever you want:

Chris

[axel_]

Hi Chris,

I am looking for a way to do it in the SQL statement. Manual change is not working in my case with 500+ columns.

Best regards

Axel