You can translate the question and the replies:

How to find Invalid views using VQL or Query

I want to find the invalid views using vql or query . This is really important as when import happens to higher environement using solution manager it really doesnt show the errored view and need to manually check all the views which is very tedious. Version : Denodo 7.0
user
19-03-2020 02:27:17 -0400
code

7 Answers

Hi, To check the invalid the views marked as invalid in Virtual DataPort, I would execute the below command in the VQL shell: > DESC DATABASE <database name> The output of this command is the list of elements of the database, in case that any view is marked as invalid it will be shown with "status: INVALID". For more information, you could refer to the [ Describing Catalog Elements](https://community.denodo.com/docs/html/browse/latest/vdp/vql/describing_catalog_elements/describing_catalog_elements) section of Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
20-03-2020 02:08:44 -0400
code
Please let me know how do I bring this in tabular format or bring this desc database <database name> . I tried by my own but it doesnt give all the details in tablular format by creating view on top of the desc command . Eg. View build on command "desc database admin" give only result set as name description admin admin database I want the other details in tablular format in the same view created and which provides the status of the view as invalid incase any of view or interface is invalid . Please help here.
user
23-03-2020 04:21:49 -0400
Hi Team, Is this possible to do in denodo ? Thanks
user
07-04-2020 04:51:24 -0400
Hi, There’s an enhancement request to add support for what you describe that’s currently being considered for a future update of the Denodo Platform. The enhancement would support adding information about INVALID views in table. Hope this helps!
Denodo Team
07-04-2020 07:21:36 -0400
code
I am looking for something like this too. After deploying a revision to a new environment, I need to know of any invalid views so I can determine if the changes in the revision invalidated any existing views.
user
08-01-2021 15:56:41 -0500
Hi, As mentioned in the previous response, the feature to get information about invalid views is part of the roadmap. In case, if you are a valid Support User, then I would suggest you to raise an enhancement request Support case to add interest for the request. Hope this helps!
Denodo Team
19-01-2021 02:23:36 -0500
code
Hi, You can get list of invalided views using below VQL select * from get_views() where input_database_name ='<VDB>' and view_status <> 'OK' Regards, Denodo Enthusiat
user
26-04-2023 02:48:45 -0400
You must sign in to add an answer. If you do not have an account, you can register here