Skip to main content
Version: Next
Databricks Interactive ClusterDatabricks Interactive Cluster

Databricks Interactive Cluster

https://www.databricks.com/
Databricks Interactive Cluster connectivity via the PyHive connector.
Installation
Required packages: pyhive
Connection String
databricks+pyhive://token:{access_token}@{host}:{port}/{database}?http_path={http_path}
ParameterDescription
access_tokenPersonal access token
hostServer hostname
portPort (default 443)
databaseDatabase name
http_pathHTTP path from cluster settings
Default port: 443
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 140/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
Extended Aggregate Functions
The base aggregates (SUM, COUNT, AVG, MIN, MAX, COUNT DISTINCT) are supported everywhere; these are opt-in per engine.
MEDIANSTDDEV_SAMPVAR_SAMP
Help improve this documentation by editing the engine spec:
Edit databricks.py