Cannot create CiviCRM view in Drupal "Error: Base table or view not found: 1146 Table drupal.civicrm
This is because you don't have civicrm_participant as a key in the array defined under CiviCRM Views Integration section. To make sure copy all the tables listed in UF Integration page to settings.php file.


Navigate to Administer -> System Settings -> CMS Database Integration
Copy and paste the $databases['default']['default']['prefix'] array in settings.php file.
Save and clear the cache of your site.


More Information at : http://wiki.civicrm.org/confluence/display/CRMDOC/Views3+Integration