I have been trying to integrate views with CIVICRM data in my backdropcms site, but failed. I followed the backdropcms documentation https://docs.civicrm.org/sysadmin/en/latest/integration/backdrop/views following all mentioned steps but its showing me SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxxx.civicrm_event' doesn't exist. Please note that i have separated backdrop and civicrm databases where xxx is the db prefix for backdrop database.
Please help me. Thanks in advance!