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 meltano variant.

Alternative variants are:

Standalone usage #

Install the package using pip: 

pip install git+https://gitlab.com/meltano/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 --variant meltano

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 #

  • Default: 50

How many records are sent to SQLite at a time?

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!