You can translate the question and the replies:

Can't create Remote table, Denodo says that the view was not found, but it exists

Hello I am trying to create a remote table in DEN80EDU23DS06 as follows: SELECT * FROM CREATE_REMOTE_TABLE() WHERE remote_table_name = 'bv_cc_case_call_remote' and query = 'SELECT call_id, location_id, problem_code, status_code, date_ticket_issued, date_call_received, case_id, agent_id FROM bv_service_call' AND datasource_database_name = 'denodo_training' AND datasource_name = 'ds_call_center' AND datasource_schema = 'CALLTRACKING' AND base_view_folder = '/1 - connnectivity/2 - base views' AND replace_remote_table_if_exist = TRUE AND replace_base_view_if_exist = TRUE; But I keed getting this error: Finished with error: Error executing query. Total time 0.143 seconds. QUERY [SELECTION] [ERROR] CREATE_REMOTE_TABLE [STORED_PROCEDURE] [ERROR] CREATE_REMOTE_TABLE [STORED PROCEDURE] [ERROR] Received exception with message 'View 'bv_service_call' not found' Received exception with message 'View 'bv_service_call' not found' The view exists and I even created a new one from the data source ds_call_center. Thank you in advance
14-04-2021 13:02:57 -0400

2 Answers

Hi, I have downloaded the latest VQL from the Configuration module of the DEN80EDU23DS couse and then followed the steps mentioned in the lab DEN80EDU23DS05LAB01 to create the remote table successfully. Please note to use the exact query provided in the lab module. If you have more questions related to this then we recommend you to write to us at Hope this helps!
Denodo Team
19-04-2021 09:13:51 -0400
Hello, Thank you very much for your answer. I figured it out, I simply forgot to change the database in VQL editor. Thank you
19-04-2021 09:36:27 -0400
You must sign in to add an answer. If you do not have an account, you can register here