You can translate the question and the replies:

Description in base views for

Hello, I want to create base views from Snowflake views. They are created well except for the descriptions of the numeric fields without decimals. Indeed, in the VQL I see that the description is correctly retrieved but then when it creates the base views, no property is added to all numeric fields with 0 decimal places. For all the other fields, I have no problem, the description is correctly transcribed. Can you help me. Thanks
Base View descrptions Decimal Type snowflake
user
12-10-2022 10:07:42 -0400
code

2 Answers

Hello, I understand that you are creating base view from Snowflake views and facing the issue that the property of the numeric field with 0 decimal places is not being reflected in the base view.Rest, all the other fields have the correct description from source to base view. In Denodo, when creating a jdbc base view the data source automatically tries to obtain the description of each field from the tables/view of the database. As the snowflake data source is of type jdbc, it should be reflecting all the description as it is from the source for all the fields. You can refer to the document[ Object Description](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/language_for_defining_and_processing_data_vql/object_descriptions/object_descriptions) to know more. You can perform following steps to troubleshoot the issue : 1. Copy the VQL of the base view and paste it in the VQL shell. Execute the VQL and see if the issue still exists. By doing this you can check that by creating the base view from VQL resolves the issue. 1. You can manually correct the required column description by running the ALTER statement in the VQL shell. You can refer to the document [Modifying a Base View](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/creating_a_base_view/modifying_a_base_view/modifying_a_base_view) to know more about changing properties of an existing base view. The ALTER command syntax to change the description of the column is as follows : ``` ALTER TABLE internet_inc ( ALTER COLUMN <field name:identifier> ADD ( DESCRIPTION = <description:literal> ) ) ``` If you need further assistance from us regarding this issue, then I would recommend opening a support case with a valid support account. Hope this helps!
Denodo Team
13-10-2022 20:55:58 -0400
code
can you also share how can we use Alter table command to add description for the base view. not column. It gives me parsing error everytime i do Alter table BASEVIEW_NAME DESCRIPTION = 'Performance stats etc etc';
user
15-06-2023 10:53:49 -0400
You must sign in to add an answer. If you do not have an account, you can register here