Step 6: Connect to the Database and Run a Simple Query

After you create a comprehensive design, you can connect to the database and run queries:

  1. Click Main Menu and click OK.
  2. Click Connect to Database and click OK.

    The vsql welcome prompt displays:

    Welcome to vsql, the Vertica Analytic Database interactive terminal.
    Type:  \h or \? for help with vsql commands
           \g or terminate with semicolon to execute query
           \q to quit
    
    =>
    vmartdb=>
  3. Use the \i meta-command to execute the Vertica-provided example query script:

    vmartdb=> \i vmart_query_03.sql

    You results will be similar to:

      customer_name   | annual_income------------------+---------------
     Emily G. Vogel   |        999998
     James M. McNulty |        999979
    (2 rows)
    
  4. Proceed to Step 7.