You can translate the question and the replies:

List Database Folders

Hi, is there a way to list the denodo folders for a particular denodo database via VQL? so for example: sandbox (database) - 0. Raw Data (folder) - 1. Interfaces (folder) - 2. Derived Views (folder) - 3. Final Views (folder) So i want to be able to output Raw Data, Interfaces etc.
user
16-02-2022 12:53:54 -0500

2 Answers

Hi, In order to list all the folders, for a particular virtual database via VQL, I will perform the following steps: * Launch the Virtual DataPort (VDP) Administration tool. * Navigate to Tools > VQL shell. * Execute the below query in the VQL shell: `SELECT name from GET_ELEMENTS() where input_database_name='<database_name>' and type='folder';` By performing the above steps, I will be able to view all the folders for a particular virtual database. For more information, you can refer to the below sections of the Virtual DataPort VQL Guide. * [**GET_ELEMENTS**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_elements) * [**Predefined Stored Procedures**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures) Hope this helps!
Denodo Team
17-02-2022 05:13:17 -0500
It seems I can do this with: “SELECT resultname FROM CATALOG_ELEMENTS() WHERE resulttype=’folder’ “
user
17-02-2022 05:25:51 -0500
You must sign in to add an answer. If you do not have an account, you can register here