How to verify collection data exists in the database

Applies to:
OpsA

Issue:

If you need to verify that data exists in the database, follow these steps.

Steps:

SSH to the Vertica DB server
cd /opt/vertica/bin
./vsql -U dbadmin -w bsmadmin99

List tables to look for the collection:
SELECT DISTINCT table_name, table_type FROM all_tables order by table_name;

Collection identified:
custom_events_haproxy4

Look for data in the collection:
SELECT * FROM opsa_default.custom_events_haproxy4;
SELECT COUNT (*) FROM opsa_default.custom_events_haproxy4;
CTRL-Z to quit