You can translate the question and the replies:

Download big query result

Hi, I am trying to download the result of a big query to csv (1 million rows) from vdp, unfortunately the application crashes after a while. I think the problem is that my pc has limited cpu and memory... is there a way to make VDP or any other Denodo program download the result to a shared location without passing through my pc? I read that a solution could be to use the Scheduler but I dont know what is it and where to find it. Ant help is appreciated, Thanks
user
08-06-2023 05:55:13 -0400
code

3 Answers

Hi, In order to export the view data from Virtual DataPort into a shared location without passing through your local machine, you can use the Denodo Scheduler. The [Denodo Scheduler](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/introduction/introduction) is a tool included in the Denodo Platform product suite that provides advanced functionalities for time-based scheduling and execution of different kinds of jobs such as exporting view data from Virtual DataPort into a CSV or JDBC-type data source. You can access the Denodo Scheduler via the Denodo Platform Control Center, and then navigate to the Scheduler module to start the Scheduler Server and the Scheduler Administration Tool. You can learn more about how to start different servers and tools in Denodo Platform in this documentation [Starting Platform Servers and Tools](https://community.denodo.com/docs/html/browse/8.0/en/platform/installation/denodo_platform_control_center/starting_platform_servers_and_tools/starting_platform_servers_and_tools). From the Denodo Scheduler, you can create a new VDP job. You can refer to this knowledge base article [Creating a Denodo Scheduler Job](https://community.denodo.com/kb/en/view/document/Creating%20a%20Denodo%20Scheduler%20Job?tag=Scheduler) for a detailed guide on how to do it. And then in order to export the result of the job into a shared location, you can configure the [Exporter Section](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/creating_and_scheduling_jobs/configuring_new_jobs/postprocessing_section_exporters) of the job. For more information on this, you can refer to the answer mentioned in this [community thread](https://community.denodo.com/answers/question/details?questionId=906Du00000000MYIAY&title=Does+Denodo+have+the+function+to+shcdule+exporting+data+from+a+view+and+send+to+a+share+folder%3F). If you have a valid support user, you may want to contact [Denodo Support](https://support.denodo.com/) to be able to better assist you. Hope this helps!
Denodo Team
09-06-2023 05:01:21 -0400
code
Thanks @Denodo Team for the answer, unfortunately my IT says that Denodo Scheduler wasn't configured during installation. Is it possible to add it after first installation? Is there an additional cost to it? Is there any other way for downloading a query result without my client crashing? Thanks
user
14-06-2023 09:36:04 -0400
Hi, It is recommended to install all the modules of the Denodo Platform even if you do not plan on using all of them as of the time of the initial installation. This is because the installer cannot add modules to an existing installation. In case of your scenario, the Denodo Platform will have to be reinstalled and reconfigured to be able to add the Denodo Scheduler module. You can learn more about it in the documentation [Using the Graphical Installation Wizard](https://community.denodo.com/docs/html/browse/8.0/en/platform/installation/using_the_graphical_installation_wizard/using_the_graphical_installation_wizard). The Denodo Scheduler tool comes with the Denodo Platform package and will not require additional cost when you install it. You can also try using the Denodo Data Catalog to export your view data into either CSV, HTML or Excel format. You can learn more about it in the [Query of Views](https://community.denodo.com/docs/html/browse/8.0/en/vdp/data_catalog/views/query#executing-a-query) documentation of the Data Catalog Guide. Hope this helps!
Denodo Team
15-06-2023 04:24:49 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here