Trying to display data from a module's table in views I'm trying to show the purl.value value on a view's page.

It seems to be grabbing all of the data, however it isn't showing in the final results. Here's my code:

function mymodule_views_query_alter(&amp;$view, &amp;$query) {
  //watchdog("view information", print_r($view, true));
  if ($view-&gt;name == 'project_management') {



    $join = new views_join;
  $join-&gt;table ='purl';
  $join-&gt;left_table = 'node';
  $join-&gt;left_field = 'nid';
  $join-&gt;field = 'id';
  $join-&gt;type = "LEFT";
  $join-&gt;extra_type = 'AND';
  $join-&gt;adjusted = 'TRUE';


    $view-&gt;query-&gt;table_queue['purl'] = array(
    'table' =&gt; 'purl',
    'num' =&gt; 1,
    'alias' =&gt; 'purl',
    'join' =&gt; $join,
    'relationship' =&gt; 'node',
  );

    $view-&gt;query-&gt;tables['purl'] = array(
    'count' =&gt; 1,
    'alias' =&gt; 'purl'
  );

$view-&gt;query-&gt;add_field('purl', 'value');
  }
}


What exactly am I missing? Do I need a view handler? I was told that maybe using hook_views_data_alter() might be better for my purposes.

How do I add a visible custom piece of data from that column on my view page?
you should map your data to views, so it will be available from views admin UI

check This tutorial where you will find the basics for describe custom data and tables to views.