Aurora PostgreSQL (Data API)

https://aws.amazon.com/rds/aurora/

Amazon Aurora PostgreSQL accessed via the AWS Data API, allowing database queries over HTTP without managing persistent connections.

Installation

Required packages: psycopg2sqlalchemy-aurora-data-api

Connection String

postgresql+auroradataapi://{aws_access_id}:{aws_secret_access_key}@/{database_name}?aurora_cluster_arn={aurora_cluster_arn}&secret_arn={secret_arn}&region_name={region_name}

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

Feature Score: 104/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

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