Parquet (destination ETL/ELT)

Settings

Note: As a prerequisite, a DuckDB database connection with the alias “duckdb” must be available.

(1) File name: Specify your output file here. Example: ./transfer/parquet/out/output.parquet

(2) Encoding: The encoding of the output file.

(3) Null values: The replacement value for destination fields without value.

(4) Source field: ETL/ELT source fields and custom ETL/ELT fields can be selected here.

(5) Source field: ETL/ELT variables can be selected here.

(6) Source field: Index columns ($COL.1, $COL.2, etc.) can be selected here. See section “CSV/Text (source ETL/ELT)”, for example.

(7) Arrow in the middle: With this you can move selected data items (4), (5) and (6) to “Columns/values” on the right. With the symbol above, entries selected on the left can be assigned to existing entries on the right in order. Drag and drop is also possible.

(8) Parquet columns: The Parquet columns you want to fill with data.

(9) Miscellaneous ETL driver settings: This is an expert setting (Scriptella) and can be ignored.