Before ingesting Vertica metadata into Dawiso, prepare your account for authentication by creating a dedicated Vertica user and granting it the necessary permissions.

Dawiso supports the traditional authentication method using credentials to connect. Only read access is required, Dawiso does not modify your data.

Supported Vertica versions

  • Vertica 10.x and later
  • Vertica Community Edition

Connection prerequisites

  • Your Vertica account has administrator-level privileges

Create new Vertica user

Create a new dedicated user (e.g., dawiso_user) using the following statement:

CREATE USER dawiso_user IDENTIFIED BY 'password';
  • Replace password with a strong password.
  • If you choose a custom username, make sure to replace it in all following statements.

For more information, refer to the official Vertica documentation.

Grant permissions

Grant the newly created user the minimum required permissions to ingest Vertica metadata using the following statements:

GRANT SELECT ON ALL TABLES IN SCHEMA v_catalog TO dawiso_user;
GRANT EXECUTE ON PROCEDURE EXPORT_OBJECTS(VARCHAR, VARCHAR, BOOL) TO dawiso_user;

The EXPORT_OBJECTS permission is required to read stored procedure source code (PL/vSQL body). Without it, procedures will be scanned but their definitions will be empty.

Sample script

You can copy and paste the following script and run it on your server:

CREATE USER DawisoIntegration IDENTIFIED BY 'Password123';

GRANT SELECT ON ALL TABLES IN SCHEMA v_catalog TO DawisoIntegration;
GRANT EXECUTE ON PROCEDURE EXPORT_OBJECTS(VARCHAR, VARCHAR, BOOL) TO DawisoIntegration;