Dremio

https://www.dremio.com/

Dremio is a data lakehouse platform for fast, self-service analytics.

Installation

Required packages: sqlalchemy_dremio

Drivers

Arrow Flight (Recommended)Recommended

ODBC

PyPI Package: sqlalchemy_dremio

dremio+flight://data.dremio.cloud:443/?Token={token}&UseEncryption=true

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 28/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 dremio.py