OMOP Export
Category: Data
Node id: omop-export
Standards: OMOP-CDM-5.4, EHDS
Exports OMOP CDM tables to CSV (tab-separated) or Parquet files, one file per table
What it does
- OMOP CDM table export to CSV (tab-separated, OMOP convention)
- OMOP CDM table export to Parquet with compression (snappy, gzip, zstd)
- Dual-format export (CSV + Parquet simultaneously)
- Per-table file generation with row counts and file sizes
- Selective table export via include_tables filter
- Path traversal security validation
Use cases
- Export OMOP CDM tables for data warehouse loading
- Generate Parquet files for analytics platforms (Spark, BigQuery)
- Create OMOP data snapshots for regulatory submissions
- Selective table export for research datasets
Runtime
- Performance tier:
medium
Input ports
| Name | Type | Required | Description |
|---|---|---|---|
omop_tables | json | Yes | OMOP table map from fhir-to-omop node |
data | json | No | Alternative input: OMOP table map |
Output ports
| Name | Type | Required | Description |
|---|---|---|---|
result | json | No | Export result containing files_written, table_stats, format, and output_directory |
success | boolean | No | Whether the export succeeded |
Settings
Basic
| Setting | Name | Type | Required | Default | Allowed values | Description |
|---|---|---|---|---|---|---|
| Operation | operation | enum | Yes | export_csv | export_csv, export_parquet, export_all | Export format |
| Output Directory | output_directory | string | Yes | Directory to write exported files | ||
| Compression | compression | enum | No | zstd | snappy, gzip, zstd, none | Compression for Parquet files |
Advanced
| Setting | Name | Type | Required | Default | Allowed values | Description |
|---|---|---|---|---|---|---|
| Include Tables | include_tables | string | No | Comma-separated list of table names to export (empty exports all) | ||
| Base Directory | base_directory | string | No | Base directory for path security validation |
Errors
| Code | Description |
|---|---|
OUTPUT_DIR_REQUIRED | Output directory must be specified |
PATH_TRAVERSAL | Output path is outside allowed base directory |
DIR_CREATE_FAILED | Failed to create output directory |
EXPORT_FAILED | Failed to write table to file |
UNSUPPORTED_OPERATION | Operation not recognized |
Runtime notes
- CSV export uses tab-separated format (OMOP convention), not comma-separated
- The node recursively searches nested input maps for OMOP CDM table keys (person, condition_occurrence, etc.)
- export_all writes both CSV and Parquet for each table; files_written values become {csv, parquet} objects
- Empty tables are silently skipped and do not appear in files_written or table_stats
See Build any workflow for how to put nodes together and Ports, types and data flow for how port types connect.
¿Algo no está claro? Envíe sus comentarios sobre la documentación por correo electrónico..