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

[erickalberto_romeroneyra]

I just tried this workaround:

1.- export the SQL view to CSN/JSON file (in Edit menu )

2.- upload the json file in a genAI chat and ask the following prompt:

" Can you update the attached CSN file and convert labels into Business names (Upper case lower case words without "_" )"

Gen AI will also ask to improve it like keeping upper cases for acronyms ..you can remove prefix or suffix..etc.. just be careful with json format double quotation marks if you copy/paste can replace that in notepad++ 

3.- import the CSN into the repository, wait the import is complete and redeploy your view.

Ref.-  Importing and Exporting Objects in CSN/JSON Files

example json code to be replaced/generated for that field

"VK_AUTOID": {
"@EndUserText.label": "AutoID",