SQLite (meltano
variant)
Table of Contents
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:
-
meltanolabs
(default)
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.