Databricks (legacy)

https://www.databricks.com/

Legacy Databricks connector using the databricks-dbapi driver.

Installation

Required packages: databricks-dbapi[sqlalchemy]

Connection String

databricks+connector://token:{access_token}@{host}:{port}/{database_name}?http_path={http_path}

Parameter	Description
access_token	Personal access token
host	Server hostname
port	Port (default 443)
database_name	Database name
http_path	HTTP path from cluster settings

Default port: 443

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 70/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

Help improve this documentation by editing the engine spec:

Edit databricks.py