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
Name | Type | Required | Description |
---|---|---|---|
port | integer | ✅ | Database port, e.g., 3306 |
user | string | ✅ | Database user to connect |
database | string | ✅ | Database name |
driver | string | ❌ | Driver name for vertica, default is vertica+vertica_python Defaults: vertica+vertica_python |
password | string | ❌ | 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_size | integer | ❌ | Connection pool size, default 5 Defaults: 5 |
max_overflow | integer | ❌ | Max overflow connections, default 10 Defaults: 10 |
pool_timeout | integer | ❌ | Connection pool timeout, default 30 Defaults: 30 |
pool_recycle | integer | ❌ | Connection pool recycle, default 3600 Defaults: 3600 |
pool_pre_ping | boolean | ❌ | Connection pool pre ping, default True Defaults: True |
host | string | ✅ | Database host, e.g., localhost |