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 #

Meltano helps you manage your configuration, incremental replication, and scheduled pipelines.

View the Meltano-specific target-sqlite instructions to learn more.

Capabilities #

Settings #

target-sqlite requires the configuration of the following settings:

These and other supported settings are documented below. To quickly find the setting you're looking for, use the Table of Contents at the top of the page.

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 the target-sqlite target to work, 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. Edit it on GitHub!