The target-sqlite Singer target sends data into SQLite after it was pulled from a source using a Singer tap.

Alternative variants

Multiple variants of target-sqlite are available. This document describes the default meltanolabs variant, which is recommended for new users.

Alternative variants are:

Standalone usage

Install the package using pip:

pip install git+https://github.com/MeltanoLabs/target-sqlite.git

For additional instructions, refer to the README in the repository.

Usage with Meltano

Install Meltano, create your Meltano project, and add the target to your project as a loader:

meltano add loader target-sqlite

For additional instructions, refer to the Meltano-specific documentation for target-sqlite.

Capabilities

Settings

Database Name (database)

  • Default: warehouse

Name of the SQLite database file to be used or created, relative to the project root. The .db extension is optional and will be added automatically when omitted.

Batch Size (batch_size)

  • Default: 50

How many records are sent to SQLite at a time?

Timestamp Column (timestamp_column)

  • Default: __loaded_at

Name of the column used for recording the timestamp when Data are loaded to SQLite.

Looking for help?

If you're having trouble getting target-sqlite to work by itself or with Meltano, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the #plugins-general channel.

Found an issue on this page?

This page is generated from a YAML file that you can contribute changes to! It is also validated against a JSON Schema used for taps and targets.


Edit this page on GitLab!