- Availability
- Airbyte Cloud Airbyte OSS PyAirbyte
- Support Level
- Archived
vertica [ARCHIVED]
This page guides you through the process of setting up the vertica destination connector.
Prerequisites
To use the Vertica destination, you'll need:
- A V ertica server version 11.0 or above
Airbyte Cloud only supports connecting to your Vertica instances with SSL or TLS encryption. TLS is used by default. Other than that, you can proceed with the open-source instructions below.
You'll need the following information to configure the Vertica destination:
- Host - The host name of the server.
- Port - The port number the server is listening on. Defaults to the VSQL™ standard port number (5433).
- Username
- Password
- Default Schema Name - Specify the schema (or several schemas separated by commas) to be set in the search-path. These schemas will be used to resolve unqualified object names used in statements executed over this connection.
- Database - The database name. The default is to connect to a database with the same name as the user name.
- JDBC URL Params (optional)
Refer to this guide for more details
Configure Network Access
Make sure your Vertica database can be accessed by Airbyte. If your database is within a VPC, you may need to allow access from the IP you're using to expose Airbyte.
Step 1: Set up Vertica
Permissions
You need a Vertica user with the following permissions:
- can create tables and write rows.
- can create schemas e.g:
You can create such a user by running:
CREATE USER airbyte_user WITH PASSWORD '<password>';
GRANT CREATE, TEMPORARY ON DATABASE <database> TO airbyte_user;
You can also use a pre-existing user but we highly recommend creating a dedicated user for Airbyte.