Skip to content

Storing aggregate covariate data in RDBMS server instead of Andromeda #152

@azimov

Description

@azimov

Currently it appears that the use of an RDBMS is supported [for storing computed features] in getDbDefaultCovariateData(

# Don't fetch to R , but create on server instead
), however it appears that this is not possible for aggregate features.

When performing feature extraction on around 1000+ cohorts, storing the aggregate features in andromeda objects on disk becomes more difficult with the size of the features.

It also looks like the code for getDbDefaultCovariateData doesn't function correctly for the non-aggreagate features as there is a discrepancy between the executed SQL statements here and here.

To store results in a new table will also probably break in the case where the tables already exist, so and overwriteTables flag should be included.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions