OpenText Analytics Database (Vertica)

Steps to complete:

Run SQL script and create schema for Datafold

To connect to Vertica, you need to create a user with read-only access to all tables in all schemas, write access to Datafold-specific schema for temporary tables:

/* Datafold utilizes a temporary dataset to materialize scratch work and keep data processing in your warehouse. */

CREATE SCHEMA datafold_tmp;

/* Create a datafold user */

CREATE USER datafold IDENTIFIED BY 'SOMESECUREPASSWORD';

/* Give the datafold user write access to the temporary schema */

GRANT ALL ON SCHEMA datafold_tmp TO datafold;

/* Make sure that the user has read permissions on the tables */

GRANT USAGE ON SCHEMA <myschema> TO datafold;
GRANT SELECT ON ALL TABLES IN SCHEMA <myschema> TO datafold;

Datafold utilizes a temporary schema, named datafold_tmp in the above script, to materialize scratch work and keep data processing in your warehouse.

Configure in Datafold

Field Name	Description
Connection name	A name given to the data connection within Datafold
Host	The hostname address for your database
Port	Vertica connection port, usually 5433. The form pre-fills 5432, so change it if needed
Username	The user role created in the SQL script; datafold
Password	The password created in the SQL permissions script
Database	The name of the Vertica database you want to connect to

Click Save. Your data connection is ready!

INTRODUCTION

DATA PLATFORM MIGRATIONS

DATA DIFFS

DATA MONITORS

INTEGRATIONS

DEPLOYMENT

SECURITY

SUPPORT

OpenText Analytics Database (Vertica)

Run SQL script and create schema for Datafold

Configure in Datafold

​Run SQL script and create schema for Datafold

​Configure in Datafold

Run SQL script and create schema for Datafold

Configure in Datafold