You can translate the question and the replies:

Run a query in a JOB to create a table

I read data from different datasources (EXCEL), and I do a complex process to get a final result. In the middle of this process I created a materialized table, to improve the performance of the process. I have a job in the scheduler, that get data from denodo and save it into an external database. My problem is that when I update the file of the datasources, I need to re-create the materialized table. So... In Scheduler, before launching my job, Could I create another job that run a query to re-create that materialized table?
user
20-05-2019 10:18:14 -0400

1 Answer

Hi, I’m not really sure if you can schedule a job to create a table in the Denodo, but you can create a stored procedure to create the table, in this stored procedure you can execute the VQL command to create the materialized table. You can find some more information on creating stored procedures here in this link https://community.denodo.com/docs/html/browse/7.0/vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures You can also refer to the sample stored procedures located here: <DENODO_HOME>\samples\vdp\storedProcedures\src\com\denodo\vdp\demo\storedprocedure Once you have developed a stored procedure you can then call this stored procedure from the scheduler job. This way you can automate the creation of the materialized table before launching your job. Hope this helps!
Denodo Team
22-05-2019 20:54:44 -0400
You must sign in to add an answer. If you do not have an account, you can register here