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: 31/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
Troubleshooting
Common error messages you may encounter when connecting to or querying Cloudflare D1, along with their causes and solutions.
Notes
No additional library needed. SQLite is bundled with Python.