Question Re: Datasphere - SQL View - Set Business Name in SQL Select in Technology Q&A

Datasphere - SQL View - Set Business Name in SQL Select

axel_ — Wed, 29 Nov 2023 14:36:21 GMT

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

Re: Datasphere - SQL View - Set Business Name in SQL Select

Chris_Tam — Wed, 29 Nov 2023 14:51:41 GMT

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

Re: Datasphere - SQL View - Set Business Name in SQL Select

axel_ — Wed, 29 Nov 2023 14:58:51 GMT

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

Re: Datasphere - SQL View - Set Business Name in SQL Select

erickalberto_romeroneyra — Tue, 04 Nov 2025 16:58:48 GMT

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",