Vertica

Vertica

The recommended connector library is sqlalchemy-vertica-python. The Vertica connection parameters are:

• User Name: UserName
• Password: DBPassword
• Database Host:
  • For Localhost : localhost or 127.0.0.1
  • For On Prem : IP address or Host name
  • For Cloud: IP Address or Host Name
• Database Name: Database Name
• Port: default 5433

The connection string is formatted as follows:

vertica+vertica_python://{username}:{password}@{host}/{database}

Other parameters:

• Load Balancer - Backup Host