RisingWave is a distributed streaming database.
Installation
Required packages: psycopg2sqlalchemy-risingwave
Connection String
risingwave://root@{hostname}:{port}/{database}?sslmode=disable| 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
Notes
The psycopg2 library comes bundled with Superset Docker images.