SQL INSERT file format#

This file format contains an INSERT...VALUES statement to be executed on the destination during the load stage.

Additional data types are stored as follows:

datetime and date are stored as ISO strings;

decimal is stored as a text representation of a decimal number;

binary storage depends on the format accepted by the destination;

json storage also depends on the format accepted by the destination.

This file format is compressed by default.

import SetTheFormat from './_set_the_format.mdx';

SQL INSERT file format#

This file format contains an INSERT...VALUES statement to be executed on the destination during the load stage.

Additional data types are stored as follows:

This file format is compressed by default.

Supported destinations#

This format is used by default by:

It is also supported by Filesystem if you'd like to store INSERT VALUES statements for some reason