Can we configure default columns in a Database view?

[Mark Nguyen]

Hello ServiceNow community,

I have a visualization using a database view in the Platform Analytics Workspace. I want to configure default columns on the database view so that when a user clicks on the visualization it opens predefined columns.

Is it possible to configure default columns in a database view?

Thanks!
Mark

[Bert_c1 · Accepted solution]

Yes it is, open the Database view record, and in the View Tables list, click one to open, then specify the table columns.

See screenshot, 

Use the "View Fields" related list to select the columns from that table.  do that for each table in the database view.

[Mark Nguyen]

Thank you!