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 #

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 (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 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!