Skip to main content
Question

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

  • August 24, 2020
  • 2 replies
  • 11 views

HyeontaeJu
Forum|alt.badge.img+2

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"

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • August 24, 2020

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
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • August 25, 2020

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