Skip to main content

Store (In Database)

Synopsis​

Stores the input data in the database.

Description​

This operator writes the input data into the database. Note that this operator requires proper CREATE TABLE privileges in the selected schema. No data is retrieved to the memory of the machine running this process unless the output of this operator is connected to a Nest output. This way, you can implement ETL processes without worrying about running out of memory, since the entire process will be pushed into the database.

Input​

example set input​

Output​

example set output​

Parameters​

Schema name​

Name of the schema.

Table name​

Output table.

Overwrite mode​

This parameter indicates if an existing table should be overwritten or data should be appended to the existing data.