Aurora PostgreSQL (Data API)

https://www.postgresql.org/

PostgreSQL is an advanced open-source relational database.

Installation

Required packages: psycopg2

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

Default port: 5432

Connection Examples

Basic connection

postgresql://{username}:{password}@{host}:{port}/{database}

With SSL required

postgresql://{username}:{password}@{host}:{port}/{database}?sslmode=require

Supported 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.

Resources

Official Documentation

SQLAlchemy Dialect Documentation

Help improve this documentation by editing the engine spec:

Edit aurora.py