Amazon Aurora PostgreSQL is a relational database engine that combines high-end commercial database speed with the simplicity of open-source PostgreSQL.
Installation
Required packages: psycopg2psycopg2
Connection String
postgresql://{user}:{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
Feature Score: 94/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
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.