> For the complete documentation index, see [llms.txt](https://cgps.gitbook.io/data-flo/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://cgps.gitbook.io/data-flo/reference-guide/export-to-sqlite-file.md).

# export-to-sqlite-file

## Description

<mark style="color:purple;">`export-to-sqlite-file`</mark> *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`