Denodo

https://www.denodo.com/

Denodo is a data virtualization platform for logical data management.

Installation

Required packages: psycopg2

Drivers

psycopg2Recommended

PyPI Package: psycopg2

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

Uses PostgreSQL wire protocol.

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 27/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 Denodo, along with their causes and solutions.

Authentication2 errors

Connection3 errors

Permissions1 error

Query4 errors

Help improve this documentation by editing the engine spec:

Edit denodo.py