跳到主要内容
版本:dev

Vertica datasource Configuration

Vertica is a strongly consistent, ACID-compliant, SQL data warehouse, built for the scale and complexity of today`s data-driven world.

Parameters

NameTypeRequiredDescription
portinteger
Database port, e.g., 3306
userstring
Database user to connect
databasestring
Database name
driverstring
Driver name for vertica, default is vertica+vertica_python
Defaults:vertica+vertica_python
passwordstring
Database password, you can write your password directly, of course, you can also use environment variables, such as ${env:DBGPT_DB_PASSWORD}
Defaults:${env:DBGPT_DB_PASSWORD}
pool_sizeinteger
Connection pool size, default 5
Defaults:5
max_overflowinteger
Max overflow connections, default 10
Defaults:10
pool_timeoutinteger
Connection pool timeout, default 30
Defaults:30
pool_recycleinteger
Connection pool recycle, default 3600
Defaults:3600
pool_pre_pingboolean
Connection pool pre ping, default True
Defaults:True
hoststring
Database host, e.g., localhost