You can translate the question and the replies:

get_view_columns

We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. 1. Is there a way to track down any transformation that has been modified manually rather than opening each transformation to get the message that the vql has been modified? 2. Is there a way to pull back all columns regardless of whether or not they have been modified manually?
get_view_columns Microstrategy VQL
user
30-09-2019 16:25:15 -0400
code

1 Answer

Hi, Using the [**GET_VIEW_COLUMNS**](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_view_columns#get-view-columns) Predefined Stored Procedure, I am able to get the column details of the view even after manually editing the VQL of the view. Further, to identify the views which has been modified, I would export the complete Virtual Database and using the editor tools like Notepad++, I would search with the key word "Formatted"="yes" to know the view which are edited manually. Currently, there is no in-built functionality to know the views which are edited manually. If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
01-10-2019 06:44:41 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here