VMware Greenplum is a massively parallel processing (MPP) database built on PostgreSQL.
Installation
Required packages: psycopg2sqlalchemy-greenplumpsycopg2
Connection String
greenplum://{username}:{password}@{host}:{port}/{database}| Parameter | Description |
|---|---|
| username | Database username |
| password | Database password |
| host | Greenplum coordinator host |
| port | Default 5432 |
| database | Database name |
Connection Examples
Basic connection
postgresql://{username}:{password}@{host}:{port}/{database}With SSL required
postgresql://{username}:{password}@{host}:{port}/{database}?sslmode=requireSupported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Notes
The psycopg2 library comes bundled with Superset Docker images.