Ocient

Ocient is a hyperscale data analytics database.

Installation

Required packages: sqlalchemy-ocient

pip install sqlalchemy-ocient

Connection String

ocient://{username}:{password}@{host}:{port}/{database}

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

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

Troubleshooting

Common error messages you may encounter when connecting to or querying Ocient, along with their causes and solutions.

Authentication2 errors

Connection2 errors

Query3 errors

General2 errors

Help improve this documentation by editing the engine spec:

Edit ocient.py