SQL INSERT file format
This file format contains an INSERT...VALUES statement to be executed on the destination during the
Additional data types are stored as follows:
dateas ISO strings;
decimalas text representation of decimal number;
binarydepends on the format accepted by the destination;
complexdepends on the format accepted by the destination.
This file format is compressed by default.
Used by default by: DuckDB, Postgres, Redshift.
Supported by: filesystem.
By setting the
loader_file_format argument to
insert_values in the run command, the pipeline
will store your data in the INSERT format to the destination:
info = pipeline.run(some_source(), loader_file_format="insert_values")