How to make a Design Table using Management Console's Design?

HyeontaeJu

Hello, I am a Vertica user.
Nowadays my company is using Vertica and I want to make a query, but the query I am trying to use is too slow.
So, I tried to proceed with the work of creating a projection using the design of Vertica MC I heard in the lecture, but when I tried to add a Design table after making it Manully, the phrase "There are no tables available for this database" appears. How can I add a design table in the manually created design tab of MC?

My process order is this
Vertica Management Console > Design > new Design(Manual) > Tables > add Tables > Then the message is this "There are no tables available for this database"

Jim_Knicely

Hi,
What DB user is your MC user mapped to? Note that two types of users can use Database Designer to create an optimal database design. DBADMIN users, and users with the DBDUSER role.
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/ConfiguringTheDB/PhysicalSchema/DBD/WhoCanRunDatabaseDesigner.htm

If you aren't a DBADMIN user, the user will have to own the tables to be successfully added to a design.

https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/ConfiguringTheDB/PhysicalSchema/DBD/DesignTablesWithSampleData.htm

HyeontaeJu

@Jim_Knicely
The mapped user is dbadmin that was made when i installed vertica management console.