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
Feature Score: 34/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
Uses the PostgreSQL driver. psycopg2 comes bundled with Superset.
Help improve this documentation by editing the engine spec: