Datasphere - SQL View - Set Business Name in SQL S...

axel_ · ‎2023 Nov 29

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

Chris_Tam · ‎2023 Nov 29

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

Datasphere - SQL View - Set Business Name in SQL Select

Know the answer?

Need more details?

Accepted Solutions (0)

Answers (2)

Answers (2)