A brief description of the database.
Installation
Required packages: psycopg2psycopg2
Connection String
postgresql://{username}:{password}@{host}:{port}/{database}| Parameter | Description |
|---|---|
| username | Database username |
| password | Database password |
| host | For localhost: localhost or 127.0.0.1. For AWS: endpoint URL |
| 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
Extended Aggregate Functions
The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.
MEDIANSTDDEV_SAMPVAR_SAMP
Notes
The psycopg2 library comes bundled with Superset Docker images.