INFOColumn-level Lineage is not supported for Vertica.
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_tmp
in the above script, to materialize scratch work and keep data processing in the your warehouse.
Configure in Datafold
Field Name | Description |
---|---|
Name | A name given to the data connection within Datafold |
Host | The hostname address for your database; default value 127.0.0.1 |
Port | Vertica connection port; default value is 5433 |
User | The user role created in the SQL script; datafold |
Password | The password created in the SQL permissions script |
Database Name | The name of the Vertica database you want to connect to, default is VMart |