export-to-sqlite-file

Description

export-to-sqlite-file adaptor exports a datatable to a SQLite DB file.

Inputs

sqlite ⁃ Type: file ⁃ Required: Yes The SQLite DB file to which data will be exported.

data ⁃ Type: datatable ⁃ Required: Yes The datatable to be exported.

table name ⁃ Type: text ⁃ Required: Yes The name of the SQLite table to which the data will be exported.

id column name ⁃ Type: text ⁃ Required: No The name of the column which contains unique row IDs.

Outputs

sqlite ⁃ Type: file A file in SQLite format with the exported data.

Examples

Example 1: Default behaviour.

Inputs:

sqlite: data.sqlite

data:

id	code	name
1	GB	United Kingdom
2	TR	Turkey
3	US	United States

table name: data

id column name: id

Outputs:

sqlite: data.sqlite

-> Exported datatable to the SQLite file data.sqlite