v_valid_dataset

SELECT row_number() OVER () AS id,

    d.schema_name,

    d.table_name

   FROM (pgmetadata.dataset d

     LEFT JOIN information_schema.tables t ON (((d.schema_name = (t.table_schema)::text) AND (d.table_name = (t.table_name)::text))))

  WHERE (t.table_name IS NOT NULL)

  ORDER BY d.schema_name, d.table_name;