Cloudflare D1 is a serverless SQLite database.
Installation
Required packages: sqlalchemy-d1
Version requirement: sqlalchemy-d1 0.2.0 or later is required for SQLAlchemy 2. sqlalchemy-d1 0.1.0 pins SQLAlchemy below 2.0 and depends on the retired dbapi-d1 package.
pip install "apache-superset[d1]"Connection String
d1://{cloudflare_account_id}:{cloudflare_api_token}@{cloudflare_d1_database_id}| Parameter | Description |
|---|---|
| cloudflare_account_id | Cloudflare account ID |
| cloudflare_api_token | Cloudflare API token |
| cloudflare_d1_database_id | D1 database ID |
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 41/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
No additional library needed. SQLite is bundled with Python.