How do I create a view that uses data from an external site
You can use views_database_connector and include connection details to your settings.php and database will be available to views

add connection details to your settings.php 

"example_db" = array (
  'default' =&gt; 
  array (
    'default' =&gt; 
    array (
      'database' =&gt; 'example',
      'username' =&gt; 'example_user',
      'password' =&gt; 'example_pass',
      'host' =&gt; 'xxx.xxx.xxx.xxx',
      'port' =&gt; '',
      'driver' =&gt; 'mysql',
      'prefix' =&gt; '',
    ),
  ),
);


and when you create a view you can choose specific table from this database to connect to

Should work for both drupal 7 &amp; 8