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
