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

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)

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

How many records are sent to SQLite at a time?

timestamp_column

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!