Data360 Govern

 View Only
  • 1.  SQL View with no variables when using Select *

    Posted 07-27-2021 09:59

    See ticket 284930.  When a view includes a SELECT * the view in Govern only displays an asterisks (*) for columns. It does not show what variable are in the view.  This does not make sense from a customer/user point of view. Someone (non technical user) is trying to use Govern to find data. If the view is how they would access the data they need, just showing an asterisks is not helpful. A user could type in an EBT trying to find Email for example. Email may be in the view, but they won't find it because Govern doesn't show or know Email is in the view.  A user of Govern should not have to then use lineage or SQL code to locate the data source of the view in order to find the source table in order to find out what data is in the view. 

    Once the table that is the source of the view has been cataloged, the View should show the columns in the View.  



  • 2.  RE: SQL View with no variables when using Select *

    Employee
    Posted 08-14-2021 16:23

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Hello Lori,

    Enhancement ticket has already created for this request thru Zendesk Ticket.