How to make a Design Table using Management Console's Design?
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"
0
Answers
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
@Jim_Knicely
The mapped user is dbadmin that was made when i installed vertica management console.