Alibaba Cloud Hologres is a real-time interactive analytics service, fully compatible with PostgreSQL 11.
Installation
Required packages: psycopg2
Connection String
postgresql+psycopg2://{username}:{password}@{host}:{port}/{database}| Parameter | Description |
|---|---|
| username | AccessKey ID of your Alibaba Cloud account |
| password | AccessKey secret of your Alibaba Cloud account |
| host | Public endpoint of the Hologres instance |
| port | Port number of the Hologres instance |
| database | Name of the Hologres database |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Notes
Uses the PostgreSQL driver. psycopg2 comes bundled with Superset.