Vertica is a column-oriented analytics database.
Installation
Required packages: sqlalchemy-vertica-python
Connection String
vertica+vertica_python://{username}:{password}@{host}/{database}| Parameter | Description |
|---|---|
| username | Database username |
| password | Database password |
| host | localhost, IP address, or hostname (cloud or on-prem) |
| database | Database name |
| port | Default 5433 |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 34/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Notes
Supports load balancer backup host configuration.
Resources