Parquet
Parquet: the parquet format, from the parquet package. Declare the package once in dependencies.yml; DRE installs it on demand:
plugins: - parquetOptions
Section titled “Options”None.
Arrow types are preserved: a decimal stays a decimal at its precision, a timestamp keeps its time zone.
Keep types in an analytics export
Section titled “Keep types in an analytics export”Use Parquet when the receiver needs typed data rather than display formatting. Starting from
the tutorial project, add parquet to dependencies.yml and change:
output: {format: parquet}One query makes one .parquet file; several queries make separate files. Preview the output
and read it back with DuckDB to verify types:
select * from read_parquet('path/to/the/generated/file.parquet')Use the path printed by the run or dre history <report> --latest --path; run folder names
change each time. The monthly finance example supplies a realistic
dataset to export by changing its format. Remove xlsx-only query columns and style settings
when doing so. invalid-output-option identifies options belonging to another format;
undeclared-plugin means parquet must be added to dependencies.
See output keys, error codes and
format.